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 Options on a Form
-
- Administrator
- Posts: 78478
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: User Options on a Form
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.
The Recordset Type property can be found in the Data tab of the Property Sheet.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1488
- Joined: 05 Feb 2010, 22:25
Re: User Options on a Form
Thanks Hans!!