more than 1 table/query on form?

[pullmyefinger]

Thanks to all that have helped before, I understand a little better now.

On a form I have a query that updates a table eventually. That works so far, but I need to add another table to the form.

Can I do that? HOW do I do that if I can? I tried putting in a record source on the form with the query already there and it blanked the form at run time.

 

[pullmyefinger]

found the info that I need, I think. subforms.

 

[Adam Caramon]

You probably do not need a subform in this situation. If the additional table that you want to access in your form is related to the first table, then you can pull fields in from both.

I suspect you need to look at your table design.