How to show a field value in form?

puffdog

Registered User.
Local time
Tomorrow, 04:01
Joined
Jul 30, 2003
Messages
17
How to show a field value in form?i want to show a value of a field in a form but from different table.
i try to read it from build event but when i preview it,it will show #Name? in my text box.
Can someone help me to solve this?

Example: Form 1 is create from table 1
then i want insert a field from table 2 in form1.
but i see #Name? in the text box.
 
puff,

Its control source should be:

=DLookUp("[Field2]", "Table2", "[Table2Key] = " & Me.Table1Key

Wayne
 

Users who are viewing this thread

Back
Top Bottom