Populating two fields, different tables

[Syerston]

The problem!!! Two tables linked by a reference field (the primary key on the first table).

The reference is keyed into a text box on a form where the control source is the primary key on the first table. I would like the reference field on the second table to be populated automatically with this value.

Any help greatly appreciated

 

[SyedAqif]

Hi

Try this

On the control source of 2nd text box write

DLookup(" [2ndTable]![RefrenceField] ", "2ndTable", " [2ndTable]![LinkField]= Forms!MyForm!1stTextBox"

Hope u'll understand that

Cheers!
Aqif