hiding results of a select query

[rlh145]

I have constructed a select query to modify 3 fields in a table. I run this query in a macro. My question is this. I would like for my user to not see the results of this select query. Is there a way to hide the results? And if not, could you recommend a way to accomplish the same thing. If more info. is needed, let me know.

Thanks!

Ralph

 

[rosenfed]

If you are refering to the message boxes that appares when you do an UPDATE query, you just need to configure the local Access that is running.
Go into tools - options, then select the modify/search tab, the you will see three options on the upper right corner named CONFIRM.
Unselect the three of them and that's it!.
On the other hand, if you are running a SELECT query, you can build a form based on that query and open it as HIDDEN.

Federico Rosenhain

 

[LonnieJohnson]

How are you making the updates? Does the Macro make the updates? ljprodev@yahoo.com
Professional Development
MS Access Applications