I'll get right to the point...
I have a form that allows a user to enter info. If a duplicate record is trying to be submitted (based on 3 fields) the user is prompted to enter an ID (one of the 3 fields) into a combo box to search for any records with that ID. I want the results, there are most likely going to be multiple records, to be displayed in either a list box or maybe a subform. The user then must select one of those records, which will be displayed on the main form, allowing them to edit the record.
Is this possible?
Thanks in advance for your expert help and advice.