Multiple source tables in access forms

[vdubill]

hello, I have a form that is using a local table. Now I want to add information from another local table to this form. I just want to populate the name and Id from another local table. Help.

thanks

 

[PHV]

Change the RecordSource of your form to a query joining the two tables.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[vdubill]

Are you crapping me?! I been messing with this for two hours trying to make some kind of iif statement and it was that easy. Thanks man. I am going to slap myself in a minute.

thanks again.