Hi there,
In my search form, I can type in a surname or firstname of a student and then any matches appear in a listbox. I have a double-click method which should allow me to double-click on a listbox item and that unique record opens. This works sometimes but in situations where there are two entries with the same surname, double-clicking on a particular entry makes no difference as the FindFirst method brings up the first record it finds.
In the attached search form I have a line of code that I think is causing this problem.
RecordsetClone.FindFirst
Any ideas on a way around this?
In my search form, I can type in a surname or firstname of a student and then any matches appear in a listbox. I have a double-click method which should allow me to double-click on a listbox item and that unique record opens. This works sometimes but in situations where there are two entries with the same surname, double-clicking on a particular entry makes no difference as the FindFirst method brings up the first record it finds.
In the attached search form I have a line of code that I think is causing this problem.
RecordsetClone.FindFirst
Any ideas on a way around this?