Edit Permissions not working

[Jacquie]

I created a form that only certain people can open. I want them to be able to
view, but not edit. On the properties box for the the form, I put no for
Allow Edits, Allow Editions, Allow Additions. But I can still go in and make
changes. Any ideas? Thanks!

 

[Arvin Meyer [MVP]]

All controls should be locked if Edits, Deletions, and Additions are set to
No. I'd first try rebuilding your form to make sure you haven't missed
something.

You can try using the code at:

http://www.datastrat.com/Code/LockIt.txt

to lock individual controls, if you like.

 

[Bob Quintal]

=?Utf-8?B?SmFjcXVpZQ==?= <[email protected]>
wrote in

I created a form that only certain people can open. I want
them to be able to view, but not edit. On the properties box
for the the form, I put no for Allow Edits, Allow Editions,
Allow Additions. But I can still go in and make changes. Any
ideas? Thanks!

How are you opening the form? If via the docmd.OpenForm method, or
a macro, make sure that your datamode is set to 'read only'

 

[Jacquie]

The data mode/read only in the macro was the clinker!! Thank you so much, Bob!!

 

[Arvin Meyer [MVP]]

=?Utf-8?B?SmFjcXVpZQ==?= <[email protected]>
wrote in


How are you opening the form? If via the docmd.OpenForm method, or
a macro, make sure that your datamode is set to 'read only'

If the form is opened Read Only, NO ONE will be able to make any edits.

 

[Bob Quintal]

If the form is opened Read Only, NO ONE will be able to make
any edits.

I believe that's what the original poster specified.