Command Button

[Bill]

Hi,

I create a button on the form. When I click the button and it will open up the query screen but I want the query as READ-ONLY instead of edit the query. How do I set "read-only" on queries?

Your help would be much appreciated.

Bill

 

[Fredg]

You have evidently already written code in the button click event to open the query.
This information is readily available in Access Help.
All you need have done is place the cursor within the word OpenQuery and press F1.

DoCmd.OpenQuery "Sales Totals Query", , acReadOnly

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


Hi,

I create a button on the form. When I click the button and it will open up the query screen but I want the query as READ-ONLY instead of edit the query. How do I set "read-only" on queries?

Your help would be much appreciated.

Bill