Find record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My issue is this:

I have a database that when I click on the Print button, it goes to a macro.
The macro currently does 3 things - opens the report for the current record
in print preview, prints out 2 copies of the report and then closes the
report. This part works great.

The form is rather long and usually after that I want to find another
record. I usually have to scroll to the top of the form, click in the field
that I want and then click the find button to enter the next record #.

What I would like to do is after I click on the print button and it does its
thing, I would like the Find record popup to come up and ask me for the
record #. I have tried to use the FindRecord macro and the GotoRecord macro.
Neither did what I wanted them to.
 
Add 2 more actions at the end of your macro:
GoToControl
RunCommand

For GoToControl, specify the name of the box to search, e.g.:
[record #]
For RunCommand, specify:
Find
 
Thank you, thank you. I knew that there was a way, but nothing was working
for me. That worked like a charm.

Ida

Allen Browne said:
Add 2 more actions at the end of your macro:
GoToControl
RunCommand

For GoToControl, specify the name of the box to search, e.g.:
[record #]
For RunCommand, specify:
Find

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Ida LaValley said:
My issue is this:

I have a database that when I click on the Print button, it goes to a
macro.
The macro currently does 3 things - opens the report for the current
record
in print preview, prints out 2 copies of the report and then closes the
report. This part works great.

The form is rather long and usually after that I want to find another
record. I usually have to scroll to the top of the form, click in the
field
that I want and then click the find button to enter the next record #.

What I would like to do is after I click on the print button and it does
its
thing, I would like the Find record popup to come up and ask me for the
record #. I have tried to use the FindRecord macro and the GotoRecord
macro.
Neither did what I wanted them to.
Click to expand...
Click to expand...
 
Back
Top