Record Source / Property Sheet

[brian4167]

I have a form that's created that pulls info from 5 tables. SO, when I click on the Record Source (in the design view of the form, top left corner), should the Record Source list all of the tables that the Form is pulling data from?

 

[namliam]

No, this is what you have queries for!

 

[brian4167]

I don't think I understand. The data was pulling over and then I added a few more fields to the form that were not initially there. Then, I started to have the problem. Any clue what may be causing this?

 

[namliam]

A form is a display of a table to the user....

This table can be an actual table or a virtual table... a virtual table is a query...
In the query you need to "join" the tables so that they become one big virtual table that you can feed to your form.

 

[brian4167]

I created the Form through the Wizard and I was thinking that it created the query when I had identified what data that I want from each table.

 

[namliam]

I never use the wizard to create a form based on different tables So I am not sure if the wizard does it.. or not... I would presume not...