Changing Permissions

[139115]

I have a form that requires a user to fill-in dates. The form's record
source is a query that includes a field that I don't want the user to be
able to edit.

I have changed the properties of the bound field to not allow edits and to
be locked. This provides visibility of the field without a chance of
editting it.

My problem is that because of the permissions necessary to input dates, I
also had to grant permissions to edit the data in the entire table. Any
user can then go directly to the table and edit fields that I don't want to
allow.

My question is -

Can I grant permissions to edit the fields in the form but not the fields
directly in the table?

Thanks in advance for your advice.

Mike

 

[Howard Brody]

One method I use is to create the form unbound to any
table. It takes a little more work but it does give you
more control over changes.

The user selects criteria, usually in a ComboBox, which
tells the database which record to look up (using
DLookUps) and the controls are populated with the
approproate data. The user makes their changes and clicks
a CommandButton to update - which is done with VBA code
(DoCmd.RunSQL), letting me control what fields are updated
and which ones can't be.

Hope this helps!

Howard Brody