You need to look at the properties for the form -- either click on the Properties button on the toolbar, or right-click on the form and then go down to Properties (last item on the list). You will be able to see if the form is based on a table or query there, from the Record Source on the Data tab.
Then click on the combobox, and go to the Data tab on the Properties window; Control Source is the first line, and if it is empty, then the control is unbound. It might be best for you to delete the combobox, then be sure the Wizard button in the Toolbox toolbar is clicked, then click on the Combobox button to add it back in; the wizard will help in setting it up. Tobi -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Margaret Sent: Tuesday, October 04, 2005 4:54 PM To: [email protected] Subject: [AccessDevelopers] Re: New fields on a form... PROBLEM!! Ok, I'm obviously doing something wrong... If I go to the Forms tab, and highlight the form in question and hit Design (Design View) I get the design of the form. That's fine... but when I go to Control Source on the combo box I have created, I cannot access the new field. Next bad question... how can I tell if a form is based on a table or query? I don't believe it to be a query. Also, on my combo box that I added, it says "Unbound". Does that have any bearing on my problem?? - Thanks!! - ME --- In [email protected], "Hoffman, Tobi K \(DYS\)" <[EMAIL PROTECTED]> wrote: > 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 Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ 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/
