Parameter queries

[Guest]

I have macros set up which print off a number of reports together, these are
based on queries which use parameters to isolate the desired record - how do
i link these so that the desired information only requires to be entered once.

The example is a macro which prints off a licence; a badge and a letter to
accompany these to the licence holder - the parameter is [Enter licence
number] on each query - as a result, once the command button is clicked to
activate the macro users have to enter the same licence number three times
for each report/query

ideally i would like the users to enter the licence number once and this
will automatically carry over into subsequent reports.

 

[Steve Schapel]

Caroline,

On the form from which the macro is activated, put an unbound textbox,
where the user will enter the licence number before doing the reports.
In yur queries, in the place of the [Enter licence number] parameter
porompt, put a reference to the textbox, using syntax such as
[Forms]![NameOfForm]![NameOfTextbox].

 

[Guest]

Stever

many thanks for your help - this works excellently!!

Caroline

Caroline,

On the form from which the macro is activated, put an unbound textbox,
where the user will enter the licence number before doing the reports.
In yur queries, in the place of the [Enter licence number] parameter
porompt, put a reference to the textbox, using syntax such as
[Forms]![NameOfForm]![NameOfTextbox].

--
Steve Schapel, Microsoft Access MVP

I have macros set up which print off a number of reports together, these are
based on queries which use parameters to isolate the desired record - how do
i link these so that the desired information only requires to be entered once.

The example is a macro which prints off a licence; a badge and a letter to
accompany these to the licence holder - the parameter is [Enter licence
number] on each query - as a result, once the command button is clicked to
activate the macro users have to enter the same licence number three times
for each report/query

ideally i would like the users to enter the licence number once and this
will automatically carry over into subsequent reports.