Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing Values from Class Module to Parameter Query

Status
Not open for further replies.

deepgrewal22

Instructor
May 2, 2005
108
I have been given a huge project at work where I allow users to input certain criteria (Location, Start Date, End Date) into a SWITHCBOARD form with CLASS MODULE coding and then these data values are input into many PARAMETER QUERIES that automatically start (DoCmd.OpenQuery). My question is:

How can I pass user input values from a Form to a Paremeter Query? (What is the VBA coding for this?)


Deep Grewal
Don't say the M word (Microsoft); you sound ignorant.
 
LARiot, thanx. I embedded some SQL into the code and this SQL inserts the output to an external table.

Deep Grewal
Don't say the M word (Microsoft); you sound ignorant.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top