Autofill textboxes on 'Afterupdate' event (1 Viewer)

[Greyowlsl]

Hi,

I have a combobox where its record source is from 'table 1' (the form's control source), however its row source is from 'table 2'.
I then have a number of text boxes which also have 'table 1' as their record source.
What i need is that when i select a value in the combobox, that the corespoinding values (matching the selected value/record) from 'table 2' are entered into the other text boxes.

Thanks,

 

[John Big Booty]

If I've understood what you are trying to do (which I'm note sure I have), I believe that the DLookup() function should do what you are after.