>>> 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? <<
>
>If the list Box is bound to the customer table (i.e., ControlSource = customer.name), it is already on the correct record. Or are you telling me that the list box's RowSource is taken from the same table as its ControlSource (in which case you have a problem because the selecting an item in the list moves the record pointer in its RowSource)? I am a little confused here. Would you please post the nondefault proprty settings for you listbox?

boundcolumn 1
columncount 4
Rowsource customer.name,maillist,addr1,city
Rowsourcetype 6 - Fields

The file is indexed on name+zip (zip is not included in the list)

Also I assume I need to do a requery after adding a new record.