Can a text box display a value from one table but record to anothe

B

blue

Currently i have set the control source for a textbox set to a field name in
Table 1 and the default value of the textbox to a field name in Table2. When
i view the form there is no default value, just an empty box.
Is this possible to do?
Many thanks

Blue
 
J

John W. Vinson

Currently i have set the control source for a textbox set to a field name in
Table 1 and the default value of the textbox to a field name in Table2. When
i view the form there is no default value, just an empty box.
Is this possible to do?
Many thanks

Blue
Click to expand...

How are you setting the default value? I'd suggest

=DLookUp("[fieldname]", "[tablename]", "optional criteria")

or setting the value of the control in the Form's BeforeInsert event.

John W. Vinson [MVP]
 
Top