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.
Christine Bieri
Center for Genome Research
Montreal General Hospital Research Institute
Montreal, Quebec, Canada
Fax: 934-8353 Email:
ichbin@genome.ri.mgh.mgill.ca