How do I reference the value in a list???

[Steff_DK]

I need to ref the value in the selected row, column 5 in a list for a DLookup.

Form_frmMyForm!List1.????????? ...

Thanks!

 

[Steff_DK]

First set the "bound column" to get data from in listbox property in the data tab. -in this case 5.

Then the value is ref'd as Form_frmMyForm!List1.Value

Thanks Steff!

You're welcome Steff!