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!

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.
-- 
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Jacquie" <Jacquie@discussions.microsoft.com> wrote in message 
news:06340E1C-FD7B-4070-A9F2-5B4D0B4CCEFD@microsoft.com...
>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! 

=?Utf-8?B?SmFjcXVpZQ==?= <Jacquie@discussions.microsoft.com>
wrote in
news:06340E1C-FD7B-4070-A9F2-5B4D0B4CCEFD@microsoft.com: 

> 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'

-- 
Bob Quintal

PA is y I've altered my email address.

-- 
Posted via a free Usenet account from http://www.teranews.com

"Bob Quintal" <rquintal@sPAmpatico.ca> wrote in message 
news:Xns9957B8F09F2FDBQuintal@66.150.105.47...
> =?Utf-8?B?SmFjcXVpZQ==?= <Jacquie@discussions.microsoft.com>
> wrote in
> news:06340E1C-FD7B-4070-A9F2-5B4D0B4CCEFD@microsoft.com:
>
>> 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'

If the form is opened Read Only, NO ONE will be able to make any edits.
-- 
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com 

"Arvin Meyer [MVP]" <a@m.com> wrote in
news:eeH6tlbtHHA.2004@TK2MSFTNGP03.phx.gbl: 

> "Bob Quintal" <rquintal@sPAmpatico.ca> wrote in message 
> news:Xns9957B8F09F2FDBQuintal@66.150.105.47...
>> =?Utf-8?B?SmFjcXVpZQ==?= <Jacquie@discussions.microsoft.com>
>> wrote in
>> news:06340E1C-FD7B-4070-A9F2-5B4D0B4CCEFD@microsoft.com:
>>
>>> 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' 
> 
> 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.

-- 
Bob Quintal

PA is y I've altered my email address.

-- 
Posted via a free Usenet account from http://www.teranews.com