Choose which Table is seen in Field List

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

Guest

I created a new form and want to add fields from a specific table, however
the Field List displays the wrong table. How do I select which table I am
entering data from?
 
The underlying table or query is specified in the Form's RecordSource
property. Right click on the square at the top left of the form design
window, select Properties, and pick the source from the dropdown list.

Hope that helps.
Sprinks
 
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

Data entry for a table from a form 2
VBA - retrieve data on last create named range from previous inserted named range 0
Data entry to table from a form 1
Data entry VBA 1
Using list box adds blank record to lookup table 1
Validation Rule assistance 0
Access Access - Is it possible to repeat fields in a form? 1
How do I hightlight field when criteria met? 7

Back
Top