Linking queries on one command button

D

David H

Hi
How do I run, say, three queries with one command button.

Also can I disable the user input required in the standard query.

David H
 
B

baconroll

Create a Macro. In the Macro Name column, name it eg. PrintQuery. In the
Action column select all 3 queries ie. open query then put the query name
below and create the 2nd one on the next line etc.

Create a command button with the wizard disabled, then in the OnClick
property, select the macro you have created. ie. if you called the macro
'command1' then you would select 'command1.printquery
 
Top