onchange event to trigger a query with new text as a parameter 1

[vix]

Hi all,
Newcomer question (can't find it in FAQ)......

I have one combobox and four text boxes on my form.
The combobox row source is a joined SQL query (2 tables) and selects using a unique identifier within my db.
Three of the text boxes reference columns in the resulting dataset but the last text box is supposed to read the text in the third box and use this as a query parameter to write in its value.
I've tried doing a 3 way join in the combobox row source but for various data reasons, it doesn't work.
Anybody got any ideas?
Thanks,
vix

 

[vix]

Don't bother, I've fixed it. ta I

 

[vb6novice]

vix,

You could try a DLookup function as the control source to that last text box.