Hi Again,

I have a listbox with multiple columns. Based on which row is selected at the time, I would like to update a textbox with one value from that row.
Ie: Say the table has ID, Name, Address, Contact. The listbox displays ID, Name and Address, returns the value of the ID (unique) and I would like to update a textbox to display the contact (if there is one).
I tried creating a query, which works if I run it on it's own, but if I try to make it the control source of the textbox, I just get "#Name?" as the value.
I appreciate any help you have to offer! :)

Christine.