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