Using macro to paste

[Francis Cunningham, Jr.]

Hi,
Is there a way to create a macro to 'gotocontrol' copy and paste the
"control" then have it entered into a parameter query. ie I want to run a
macro that first will go to the control on a form named "Policy Number" then
copy that 'policy number' continue the macro to run a parameter query and
paste the desired 'policy number' and run the query based only on that
'policy number'

Any help I thank you.
Frank

 

[Steve Schapel]

Frank,

The easiest way to do this is to directly refer to the form control in
the query criteria, for example in the place of a parameter prompt in
the query, put the equivalent of this...
[Forms]![NameOfForm]![NameOfControl]