Command Button

  • Thread starter Thread starter Bill
  • Start date Start date
B

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
 
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
 
Back
Top