Execute Query in Form

[Dave Ruhl]

Hello, I know how to code a form to run an SQL
satement/query, but how do I run a saved Access query ?
I want to click a button on the form and have it execute
the saved query. Thanks!

 

[Dave Ruhl]

And what would that VBA command be ???

 

[Ron Weiner]

Dave

See if

DoCmd.OpenQuery (strYourQueryName,acViewNormal,acReadOnly)

Does what you want.

Ron W

 

[Dave Ruhl]

Thanks Ron, that's exactly what I wanted!

-----Original Message-----
Dave

See if

DoCmd.OpenQuery (strYourQueryName,acViewNormal,acReadOnly)

Does what you want.

Ron W




.