Ray- Actually, I pride myself in being to write clearly. So, if you didn't get it the first time, I apologize for not being specific enough.
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ > -----Original Message----- > From: Ray Todd, Jr. [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 29, 2005 7:59 AM > To: ms_access@yahoogroups.com > Subject: [ms_access] Re: Forms -Text Box - #Name? Error > > > > > John, > > Thank you for your help. I can be rather dense and I was just plain > stumped on this. I had obtained several books from the library and > couldn't find the answer. > > Thanks, > > Ray. > > --- In ms_access@yahoogroups.com, "John Viescas" <[EMAIL PROTECTED]> wrote: > > Ray- > > > > Ummm. I just did. Let me be more specific: > > > > 1) Open the form in Design view > > 2) Open the Properties window > > 3) Select the form and find the Record Source property - should be > at the > > top of the window on the All properties tab. > > 4) Click in the property and then click the Build button next to it > (the one > > with the three dots on it) > > 5) In the query designer window, click the Show Table button on the > toolbar > > (the one with the yellow plus-sign and a little datasheet), find the > table > > you want to add to the query, select it, and click the Add button. > Close > > the window when you're done. > > 6) Make sure Access has drawn a line from a field or fields in one > of the > > existing table to the one you just added. If not, your result - and > your > > form - won't be updatable. > > 7) Drag and drop the field you want to add to the query grid. > > 8) Close the designer and click Yes if it asks you if you want to > update the > > form property. > > > > You should now be able to select the new field as the Control Source > of a > > control on your form. > > > > John Viescas, author > > "Building Microsoft Access Applications" > > "Microsoft Office Access 2003 Inside Out" > > "Running Microsoft Access 2000" > > "SQL Queries for Mere Mortals" > > http://www.viescas.com/ > > > > > > > > Yahoo! Groups Links > > > > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> 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/
