Record Source??

[Dr. Hung]

Hey I have a form with many fields in it from several different tables.
Nomatter what I seem to try in the record source area in the properties
of the form All the information will not display correctly.

Should I have a query for this and If so what should it be, or what
code should go in the box??

I'd appriciate any help thanks!!

 

[Armen Stein]

Hey I have a form with many fields in it from several different tables.
Nomatter what I seem to try in the record source area in the properties
of the form All the information will not display correctly.

Should I have a query for this and If so what should it be, or what
code should go in the box??

I'd appriciate any help thanks!!

If you need to join information from multiple tables, build a query
first, then base your form's recordsource on that query.

However, if the form is updatable and the related tables are just for
lookup values, then instead of joining them in the main query, you can
use a combobox to display each one.