Hi Nick.

>> Just to add: I always use listbox.DisplayValue for this purpose, because .Value and .DisplayValue may be different, and I want to make sure that I set the property which I actually can see in the listbox. <<


Since, in this case, the listbox has a RowSourceType of either 2-Alias or 6-Fields this is totally unnecessary. Setting the listbox's value will move the record pointer in the underlying data source and take its DisplayValue from whatever has been defined as the first column of the RowSource.

Marcia