Bring up the form in Design mode by going to the database window, to the Forms tab; right-click on the form name and select "Design". You can bring up the fields that are in the data source. If the data source is a query, you will first need to edit the query and add those fields in. If the data source is a table to which you have added the field, you should see the field, and you can either drag the new field onto the form, or add the textbox and assign the new field as its source. Hope this helps get you started!
Tobi -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Margaret Sent: Tuesday, October 04, 2005 3:26 PM To: [email protected] Subject: [AccessDevelopers] New fields on a form... PROBLEM!! 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. Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/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/
