p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Paramater Query


Message #1 by stevewardau@y... on Wed, 19 Jun 2002 08:31:12
I have a form based on a Parameter Query.

Is there a way to have the Parameter run from a list box with a drop down 
list of variables?

Any help would be appreciated.

Stephen Ward
Australia
Message #2 by "Richard Lobel" <richard@a...> on Wed, 19 Jun 2002 00:35:54 -0700
Set the parameter to the name of the form and the name of the control.
For example, if the drop down list is named cboEmployee and its on a
form called frmSource, the query criteria should be set to
Forms![frmSource]!cboEmployee. Then in the Click event of the cbo box
run the query.

***original message***
I have a form based on a Parameter Query.

Is there a way to have the Parameter run from a list box with a drop
down 
list of variables?


Richard Lobel
President
NoClassroom.com
Live Online Training
richard@n...
Tel:   (xxx) xxx-xxxx
Fax:  (xxx) xxx-xxxx




  Return to Index