Text Box contents based upon value selected in List Box 1

[benwah]

Gday Gday

I have a list box on a form and when the user selects a value from that list box (AppraisalID), the text box next to it will display the associated details (AppraisalDetails).

Thats how I would like it to happen in theory but am having trouble getting it to work!

The form is based upon a Query that returns the AppraisalID and Details for the relevant Employee (EmpID).

Thanks in advance

wah

 

[bpurser]

Well, I've never once used a listbox (prefer combos) but in a combo, you'd select the additional fields you want to use as part of the rowsource, then reference them by the column prop.

me.textbox=me.combobox.column(1) would pull the data from the SECOND column of the combo's selected row (they're 0 based). I assume listboxes work in a similar fashion, though you might have to throw in the itemselected or itemdata prop as well...

HTH
Ben

 

[benwah]

Perfect! Thanks!

Wah