Criteria List

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

Guest

Would like to have a list of valid Values for a field to drop when Q is ran.
For example, Start Q--Use Between[x] And [y] for date range, then the list
box would open to select a choice to satisy the next criteria. How would
this be accomplished?

Thanks
 
Hi,


Start by opening the form that will present the combo box, and once done
(AfterUpdate of the combo box), run the query. For the end-user, it seems
that query asked for the parameter, but only you can tell that indeed,
first, was the form, then was the query executed. So, rather that "hanging"
from the query waiting the user enter something, you delay the query
execution until you got nicely captured all the parameters.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top