Re: Renegade Form

Based on the information provided, they would have only read permission.
Double-check each user's permission, as well as 'the' group of interest.

In addition, double-check other groups that the user(s) belong to i.e. Users
and any other custom groups. You are overlooking something.

--
Joan Wild
Microsoft Access MVP
"NevilleT" <NevilleT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:54D9C77A-A19A-4CBB-9CCE-5CC4E0C79CA3@xxxxxxxxxxxxxxxx
I have an application with a number of forms. I can control read only
access
to forms through a group in the workgroup file for all but one form. The
form uses a query that includes 2 tables.

- The form security is set to Open/Run only
- The query used for the form is set to Read Design and Read Data
- The tables that form the query are set to Read Design and Read Data

I wanted users who are part of this group to only read data. Problem is
they can modify data on the form. I have checked individual permissions
for
the users and there are none set. The only odd thing I do with this form
is
to set some properties depending how it is opened based on a parameter
passed
to it by the particular button used to open it.

NewProjScr = Forms!frmProjectTab.OpenArgs

If NewProjScr = "1" Then
Me.AllowAdditions = True
Me.DataEntry = True
Else
Me.AllowAdditions = False
Me.DataEntry = False
End If

Can anyone suggest why the read only permission is being overridden for
this
form?



.

Loading