User Options on a Form

Leesha
BronzeLounger
Posts: 1488
Joined: 05 Feb 2010, 22:25

User Options on a Form

Post by Leesha »

Hi,
I have a form that is bound to a query that has 3 joins. The form is only meant to view the data. This works fine. Recently we found that if you right click on a cell, some people have the option to copy, others have the option to copy or cut and others have the option to copy, cut or paste. None of these options should be available. What confuses me is why it's different on the various computers. I'm assuming it has to do with the user option settings. How do I make this uniform between all users?
Thanks,
Leesha

User avatar
HansV
Administrator
Posts: 78457
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: User Options on a Form

Post by HansV »

I don't know what causes the problem, but if you set the Recordset Type property of the form (or of the query) to Snapshot instead of the default Dynaset, the form will be read-only.
The Recordset Type property can be found in the Data tab of the Property Sheet.
Best wishes,
Hans

Leesha
BronzeLounger
Posts: 1488
Joined: 05 Feb 2010, 22:25

Re: User Options on a Form

Post by Leesha »

Thanks Hans!!