Passing Form Values to Queries

[Simon]

Hi,

I have a query is it possible that when the query is run, a form will pop-up
prompting the user to enter values. At the moment I have a form, I can enter
data on the form and pass the values through to my query ok but I want the
form to pop up when the query is run, is there a way of doing this?

Thanks.
Simon

 

[Jeanette Cunningham]

Hi Simon,
use code to open the popup form when you are ready to run the query.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[John Spencer MVP]

Open the form in dialog mode from the reports load event. Opening the form in
dialog mode stops code from running in the report until the form is no longer
visible

After the user enters the parameters on the form, do NOT close the form.
Instead set the form's visible property to false.

In the close event of the report, you can close the form (or make it visible
if you wish to do something else with the form).

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[John Spencer MVP]

Whoops. In a QUERY there is not a way to automatically pop up the form for
parameter entry.n

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County