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 AccessDevelopers@yahoogroups.com, "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: AccessDevelopers@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of Margaret > Sent: Tuesday, October 04, 2005 3:26 PM > To: AccessDevelopers@yahoogroups.com > 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/
