Macro running Queries

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

Guest

I have a macro running a series of queries.
I would like to code some of the responses to the query promts in the macro.
I have tried, unsuccesfully, to put the data in the Condition field of the macro.
How can this be done?

I would also like to use the entered responses to the first query in the second query.
Is this possible?

Your help is greatly appreciated!
Rick
 
Rick,

If you are referring to criteria of the queries, you can set up
whatever unbound controls (textbox, combobox, etc) on a form which
will be open at the time that your macro is executed. Then, you refer
to these controls directly in the query criteria, in the place of the
parameter prompts which I presume you are now using. Use syntax such
as [Forms]![NameOfForm]![NameOfControl]

- Steve Schapel, Microsoft Access MVP
 
Back
Top