I want to have the FindRecord box pop-up when I open a form.

[Guest]

I want the focus to land on a field called [ID] which I solved with
GoToControl. But I can't seem to get the hang of the FindRecord command. In
the arguments section, what do I put in FindWhat? Am I tackling this wrong?
I want the user to open the form, have the FindRecord box pop up so the user
can enter an ID number to go to a specific record. I'm using Access 2003.

 

[Steve Schapel]

JD,

There is no "FindRecord box" to pop up.

A good way to do this is put an unbound textbox in the Form Header,
where the user can enter the ID number of the record they want. In such
instances I usually use a different background colour for the this
textbox to help make it clear that it is a criteria-related control, not
data. Let's say the name of this textbox is FindID. Ok, then in the
Find What argument of the FindRecord action in your macro, you would put...
=[FindID]
You can assign the macro on the After Update event of the FindID
textbox, or you could put a command button alongside the textbox and
assign the macro on the button's Click event.

 

[Guest]

Thank you - I'll try that. I guess I thought there was a way to automate the
Ctrl/F function which would pop up the box for Find/Replace. But if this
works - problem solved. Thanks for the quick response.

JD,

There is no "FindRecord box" to pop up.

A good way to do this is put an unbound textbox in the Form Header,
where the user can enter the ID number of the record they want. In such
instances I usually use a different background colour for the this
textbox to help make it clear that it is a criteria-related control, not
data. Let's say the name of this textbox is FindID. Ok, then in the
Find What argument of the FindRecord action in your macro, you would put...
=[FindID]
You can assign the macro on the After Update event of the FindID
textbox, or you could put a command button alongside the textbox and
assign the macro on the button's Click event.

--
Steve Schapel, Microsoft Access MVP

I want the focus to land on a field called [ID] which I solved with
GoToControl. But I can't seem to get the hang of the FindRecord command. In
the arguments section, what do I put in FindWhat? Am I tackling this wrong?
I want the user to open the form, have the FindRecord box pop up so the user
can enter an ID number to go to a specific record. I'm using Access 2003.