G
Guest
Greeting! Thanks for taking the time to look at this!
I've done very little with VBA so I might be trying to do something that
can't be done. Here's what I'm trying to do:
I have a Parameter Query named "Q-Temp" which uses the criteria of
"Like [Please type Vehicle Type]"
So when you run the query from the database view, you get the Enter
Parameter dialog asking you to key-in the vehicle type. This works just great
this way. The field VehicleType is an Integer if that matters...
I need to run that query from VBA. Is there some code that I can add before
or after my:
DoCmd.OpenQuery "Q-Temp"
so that the parameter is passed without the Enter Parameter dialog opening?
Thanks,
Giddy
I've done very little with VBA so I might be trying to do something that
can't be done. Here's what I'm trying to do:
I have a Parameter Query named "Q-Temp" which uses the criteria of
"Like [Please type Vehicle Type]"
So when you run the query from the database view, you get the Enter
Parameter dialog asking you to key-in the vehicle type. This works just great
this way. The field VehicleType is an Integer if that matters...
I need to run that query from VBA. Is there some code that I can add before
or after my:
DoCmd.OpenQuery "Q-Temp"
so that the parameter is passed without the Enter Parameter dialog opening?
Thanks,
Giddy