open other table field list when designing from

K

KK

Could anyone told me how to open the field list that from difference
table,please?
Because I want to add difference field from difference table and i have
already done part of the from so don't want to use wizard to do again. Thank
you.
 
K

Klatuu

You can't do that. A form can have only one record source. If you need to
include fields from more than one table, you either need to create a query
that joins the tables and use the query as the form's record source or you
need to create a subform that has the other table as its record source.
 
K

KK

thank you

Klatuu said:
You can't do that. A form can have only one record source. If you need to
include fields from more than one table, you either need to create a query
that joins the tables and use the query as the form's record source or you
need to create a subform that has the other table as its record source.
Click to expand...
 
Top