A
Allen Browne
If you run this command in the Click event of a command button on your form,
then the *button* has focus. Naturally Access cannot search for data in the
button. You need to set focus to the text box you need to search if you want
that option.
Example:
Me.Surname.SetFocus
DoCmd.RunCommand acCmdFind
then the *button* has focus. Naturally Access cannot search for data in the
button. You need to set focus to the text box you need to search if you want
that option.
Example:
Me.Surname.SetFocus
DoCmd.RunCommand acCmdFind