Run a Query but not open ?????

[JONBOY74]

Hi all

I have a query that I wish to run but not open, how do I do this???

Thanks Jon

 

[WildHare]

What the query does is dependent on what TYPE of query it is. A SELECT query will always open a "datasheet" view of the data it pulls out. An ACTION query will 'run', but you won't necessarily see anything happen.

What KIND of query do you have?
Remember, you're unique - just like everyone else
You're invited to visit another free Access forum:

http://www.forumco.com/jmhare

or my site,

http://www.jmhare.com

 

[suziqueue]

Jon - there's actually several ways you can do this but try this - add this bit of code to a command button on a form

docmd.openquery ("query name&quot