Trying to add a field from another table on a form

F

FergusonH

I've added relationship between the form's master table and the other table.
I've updated the control source on the txt box to the table/field that I need
(=
![field]) but all of the fields are displaying as "#Name?" on my
form. I'm sorry, I know this is probably something stupid.
 
K

KARL DEWEY

Use a query as the forms source and join the tables in the query. Redo the
text box control source.
 

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

Access How to remove a non-existent field from a form's Field List 0
Select field from table not used by form 6
Calculate form field using another table, Dim statement 0
add field to form from different table 2
Trying to add Long Integer field 1
DELETE FROM a table WHERE... 1
Access Create option group without using wizard? 2
Adding a field value, based on another field 6

Top