Parameter Query

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

Guest

How do I get a parameter query to allow me to use a combo box to select my
search criterai rather than have the user type the info. If they type the
info incorrectly it either does not provide all the records or provides to
many records.
 
Hi,


Make a form with the combo box. In the After update event of the combo box,
write code that will run the query, with DoCmd, and with the parameter
having the syntax

FORMS!formNameHere!ComboboxNameHere


Instruct your end user to get the query by first opening the form (or hide
that aspect of the logic within a macro or a subroutine) : the end user
will just see a form asking for a parameter, as usual, unaware that you have
not yet really start the query !


Hoping it may help,
Vanderghast, Access MVP
 

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

Similar Threads

Basing a query on the selection in a Combo box parameter 2
Parameter Query Won't Run 0
How to use txtboxes and Combo boxes in a form 3
How do I make query parameters with a drop down list? 1
problem with operator in select query 4
Using Combo Boxes as a Source for Parameter Queries 2
Modify Parameter Query 1
Query parameter 1

Back
Top