Parameter Query

T

terryh70

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.
 
M

Michel Walsh

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
 
Top