A
azu_daioh
How do I move to the previous record?
I have an unbound control (findDoctor) where the user could type in
the doctor's last name. The matching record is displayed in the bound
controls with the doctor's license number, last name, first name,
specialty.
There are two buttons, first is the "find" button:
findMe = "*" & Me.findDoctor & "*"
DoCmd.GoToControl "drLName"
DoCmd.FindRecord findMe
The 2nd button is labeled "next":
findMe = "*" & Me.findDoctor & "*"
DoCmd.GoToControl "drLName"
DoCmd.findnext
But once I clicked on the "next" button there is no way to move back
to the previously found record. I tried DoCmd.GoToRecord , ,
acPrevious but of course that moved me to the previous record on file
but not the previously matching record.
Any help is appreciated. Thank you,
I have an unbound control (findDoctor) where the user could type in
the doctor's last name. The matching record is displayed in the bound
controls with the doctor's license number, last name, first name,
specialty.
There are two buttons, first is the "find" button:
findMe = "*" & Me.findDoctor & "*"
DoCmd.GoToControl "drLName"
DoCmd.FindRecord findMe
The 2nd button is labeled "next":
findMe = "*" & Me.findDoctor & "*"
DoCmd.GoToControl "drLName"
DoCmd.findnext
But once I clicked on the "next" button there is no way to move back
to the previously found record. I tried DoCmd.GoToRecord , ,
acPrevious but of course that moved me to the previous record on file
but not the previously matching record.
Any help is appreciated. Thank you,