call a existing query in vba

jamest85

Registered User.
Local time
Today, 04:34
Joined
Jan 20, 2008
Messages
52
Hi:
Haven't use MS Access for a while.
I just create a query called qryAppendDate, how can I call in my vba code.

Something like: docmd.runquery ????

( I created the query by using "Create query by using wizard").

Thanks

JT
 
Last edited:
Here's one way
Code:
DoCmd.OpenQuery "your_query", acNormal, acEdit
 

Users who are viewing this thread

Back
Top Bottom