Ok, I am EXTREMELY new to Access, and therefore and having difficulties that you experienced folks might find naive, stupid, etc. But here goes...
I have been playing around trying not to reinvent the wheel by using the "Northwind" database supplied by Access. Actually, it will probably suit my purposes as soon as I make the necessary changes. I have run into a problem though... When I am in the Orders form, I want to add a couple of more fields that I have inserted into the Orders table. I am not having a problem with them showing up on the form, I think I did that right (though that could be where my problem is) - I used SELECT DISTINCTROW on a combo box and it did look up my data from my other table/query correctly. The problem is, it isn't saving to the Orders table. I think the problem may lie in the Control Source field, but the field name is not there to use. How to you instruct a "pre-made" form to accept fields that have been entered after the construction of the original form/table? Ok, there is probably a really simple explanation to this, I am just not as experienced yet. Don't be at all surprised to read more posts from me scratching my head. Many thanks in advance. ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
