open other table field list when designing from

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Form for Parts-Tools Lists 0
Data entry to table from a form 1
Can't create a report from my query in Access 1
Access Create option group without using wizard? 2
Data entry for a table from a form 2
Data entry VBA 1
MS ACCESS 2013 Long Text filed filter by another tables Long text field 1

Back
Top