Find Record Command Button asking for argument - Find what?

[PeanutB7]

I have include a find record on a form and used the button wizard. Regretfully it is coming up as an error asking find what?

The Action Failed Dialog Box States:

Macro Name - Find Record
Condition - True
Action Name - FindRecord
Argument - ,WholeField, No, All, No, Yes, Yes


Could anyone please tell me the complete argument to include and how to include this.

I have attempted the F1 key but to no avail. I would certainly appreciate your assistance.

Thank you for the time!

 

[Trevil]

Hello,

It appears that you created a MACRO, then had the command button 'On Click' event execute that macro (I can duplicate your problem).

Why not just insert the command button, use the wizard and select "Find Record"

If not, you will need to change your macro to insert a "GoToControl" before the "FindRecord"

 

[Zion7]

Yes, PeanutB7, as Trevil said...

Alternately, from the same command button you run the Macro, at the top, set focus to the control, you're doing the search on.

Private Sub cmdMacro_Click()

txtCity.SetFocus

Docmd.RunMacro....