REQUERY INSIDE THE FIND COMMAND BUTTON

[Vicki]

I’m looking for a way to attach a requery command to the find command button

I've placed the following in the command line of the find record command button as indicated below

Private Sub FindRecord_Click(
On Error GoTo Err_FindRecord_Clic

Screen.PreviousControl.SetFocu
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer7

Me.Requery ----------------------------------------------------------------I've added this command

Exit_FindRecord_Click
Exit Su

Err_FindRecord_Click
MsgBox Err.Descriptio
Resume Exit_FindRecord_Clic


End Su

Works great accept for one problem. When you try to search on a different field other then the first field in the form the find command doesn't work