Results 1 to 5 of 5
2001-06-18, 19:34 #1brobertsGuest
If you create a form from a table and later need to include information from another table, can you add it to the form? I can't figure out how to do this.
Thanks for your help.
Access 2000 SR1
2001-06-18, 20:06 #2
- Join Date
- Dec 2000
- Sacramento, California, USA
- Thanked 1 Time in 1 Post
First, base your form on a query rather than on a table. Then all you have to do is add the additional table to the query and join the two tables appropriately. After that, the fields in the second table will be available for you to show on your form.Charlotte
2001-06-18, 20:13 #3brobertsGuest
yes, I could do that but I would lose the whole form that I've already created and have to start from scratch. I wanted to add info from a table to an existing form without having to recreate the form.
2001-06-18, 20:17 #4
- Join Date
- Jan 2001
- Indianapolis, Indiana, USA
- Thanked 0 Times in 0 Posts
You won't loose the form. Just open the form into design view, select Edit | Select Form, then click the Properties button. Click the Data tab, then change the Record Source from the original table to the new query. Assuming you don't change any of the existing field names, the form should function just as it did when it was linked to the table.
HTH <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15><big><font color=blue>- M</big><font face="Comic Sans MS">ark</font face=comic><big>J -</big></font color=blue>
<IMG SRC=http://www.wopr.com/w3tuserpics/MarkJ_sig.gif border=0>
2001-06-18, 20:30 #5brobertsGuest
thanks for the tip. I really didn't want to waste all that time to create another form.