How to create a macro to run unbound form for parameter query?

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

Guest

Hi, I have created an unbound form and a parameter query. The info on the
form is supposed to generate the query. How do I create a macro such that
when it runs, it will copy the information on the form to generate the query
without the parameter pop-ups showing up? Thanks!
 
1. The data in the form needs to be set so that it it is the criteria in
your query. Right click in the space for criteria and choose Build..
2. On the same form, use a button to open that query......

Voila

Bob Galway
 
GoCards,

In the design view of your query, in the Criteria row of the relevant
fields/columns, you will enter a reference to the control on the unbound
form where the criteria for that field will be entered. The syntax of
the criteria entry will be like this...
[Forms]![NameOfYourForm]![NameOfControl]
It sounds like in some cases this criteria entered will replace an
existing Parameter prompt.
 
Back
Top