Linking a text box in a form problem

  • Thread starter Thread starter Paul Watkins
  • Start date Start date
P

Paul Watkins

Hi
I have a form which has a record source as table1.with various textboxes
linked to fields within table 1
Within this form i have one textbox which i want to display text that has
been entered into a text box in table 2
Is this possible, and if so how would i do it

Thanks

Paul
 
Hi
I have a form which has a record source as table1.with various textboxes
linked to fields within table 1
Within this form i have one textbox which i want to display text that has
been entered into a text box in table 2
Click to expand...

Which record in Table 2? There might be a million records. How are
Table1 and Table2 related?
Is this possible, and if so how would i do it
Click to expand...

A Combo Box might work; you might be able to use DLookUp; or you could
base the Form on a query joining Table1 and Table2. Without knowing
more about your table structure it's impossible to say which would be
best.
 
Back
Top