Thanks a lot. That explains it precisely. An earlier programmer had hidden it in the users system by making the primary key the same as the record number and never ordering the sql query which populates the combobox! This was OK until records were deleted.