Passing Form Values to Queries

  • Thread starter Thread starter Simon
  • Start date Start date
S

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
 
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
 
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
 
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
 
Back
Top