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

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!
 
B

bob

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
 
S

Steve Schapel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top