>>I have a table with a listbox (RowSourceType= 6-Fields) bound to the customer's name field in the customer file. Names are indexed and not unique. When I create a new record with a name that is the same as other records (and therefore already showing in the list) how can I make sure the listbox.listindex jumps to the correct record when I save the new record? The problem is like, "what list1.listindex value corresponds to record 1234?" If I knew that, I could set the listbox pointer correctly like:
>>
>>ThisForm.List1.Listindex = n
>>
>>where n points to the new record.
>>
>>This has got to be a common problem. Can anyone help?
>>
>>Thanks a bunch,
>>Allen
>
>You know the new value so TRY,
>ThisForm.List1.DisplayValue=NewValue
>
>
>HTH

I have but it's not reliable because the new value is not necessarily unique to existing display values. That method works fine if the value is unique.