Question Query Question

[GaryInMilwaukee]

From sql I want to access a saved query and use a variable within that query.

I have a button on a form that pulls an [Event Procedure]. In that event procedure (private sub) I want to declare a variable and run a saved query using that variable.

Normally I'd have the name, lets say CA, in the query and run it that way.

 

[vbaInet]

Have a search on the forum on how to run queries using vba.

Fyi: this sort of question would normally come under the QUERIES or MODULES AND VBA section of the forum.