I am trying to run a macro (attached to a command button) which will find record(s) matching a user-typed field.
A problem occurs if there is more than one record matching the criteria. I want the macro to go the first record, then if run again to go to the next one, and so on. But it just keeps finding the first record again and again.
Access Help suggests this:
"To avoid this problem...set the focus in the macro to the field containing the search criteria before you carry out the FindRecord action."
Any ideas how to do this? I do have a "GoToControl" action before the FindRecord action, and I have "FindFirst" set to No.
A problem occurs if there is more than one record matching the criteria. I want the macro to go the first record, then if run again to go to the next one, and so on. But it just keeps finding the first record again and again.
Access Help suggests this:
"To avoid this problem...set the focus in the macro to the field containing the search criteria before you carry out the FindRecord action."
Any ideas how to do this? I do have a "GoToControl" action before the FindRecord action, and I have "FindFirst" set to No.
