Find Next button fails to find records

[daveatthewell]

I have two membership type databases (they are in no way connected, I mention both for illustrative purposes) Both use a form to input data, the control source for each form is a query and each query updates respective tables. In both databases, there is a Command Button the purpose of which is to find a record based on the member's surname ie a Find button which calls the built in "Find and Replace" dialog. The code generated by Access is identical viz:

Private Sub cmdFind_Click()

    Me![LastName].SetFocus
    DoCmd.RunCommand acCmdFind

End Sub

In one database the command button works as intended, Displays the built-in Find and Replace dialog and displays the first record found with that surname; clicking the "Next" button (on the dialog) finds the next records (assuming one exists).
On the other database, the Command button brings up the dialog, finds the first record, but refuses to find any further records (which do exist and are spelt correctly with no trailing or leading spaces) displaying the message that "Microsoft Access finished searching the records. The search item was not found". If I close the dialog and click the command button again, then click Find, it finds the next record, but again doesn't find subsequent records. Where is the code for the "Find Next" button on the dialog stored because it's obviously not receiving the search parameters.
Anyone got any thoughts on this one?

BTW including:

    Screen.ActiveControl.SetFocus

which I believe is generated with a Find Next Command button has no effect.

Regards Dave

 

[daveatthewell]

I have found out what the problem was. For one reason or another I made the last statement on the On_Current event for the form in question switch the focus to another control - every time the Find routine found the first record, the Forms Current Event triggered and the focus switched away from the LastName control and therefore Find Next was never going to work. Doh!

Sitting in the corner with a pointy hat on.