Hello
This is my first time to post here so please forgive me if I don't exactly get it right. My level of knowledge in Access is novice or a little better, to compare it to a college level course I would equate it to about an "Access 102", maybe 103 so I beg your patience if I don't use the correct terminology.
The Problem
I am using a listbox to search for a record and when I click on a record where the record number selected comes after a gap in the recordset (via deleting a record), it displays the next record. I have searched everywhere and cannot find a solution. The correct record is retrieved where the record number selected is before the gap.
Please let me know what information you need me to provide that would help.
Thank you very much,
John A.