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

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

Guest

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
 
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]
 

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

how to set the Default Value of a Control Box to a Lookup Table 0
Can a record in a table have a default value from another table? 3
copy text box value from current form to "Next" form 1
Default Value Coming from Another Value 1
Problem with Default Value in Form Text Box 9
Default Value for a Text box field 1
Table Default Values 1
use a list box to populate a text box 6

Back
Top