Read only form suddenly becomes editable

[Pete]

Re Access 2003

I have developed a security framework which sets the AllowEdits,
AllowAdditions & AllowDeletions accordingly: 1=No Access (form closes),
2=Read Only & 3=Full Access. This all takes place in the Form_Load event. If
set to read only, the user can view, but cannot edit or add a record.
This all works fine when the user is typing directly into text boxes etc.

The problem:
I have a button in the detail section on the form, which uses the Windows
file dialog to add the full path/filename to a locked textbox on each record.
When the user selects a file this way, Access suddenly switches the form to
be editable - all of its own accord (

I can, of course, disable the button if the form is opened as Read Only, but
is this normal behaviour from Access??

Many thanks.

 

[Linq Adams via AccessMonster.com]

Yes, this is standard behavior! When you have a 'locked' form and you change
a control's data using code, the current record is no longer 'read-only'
until the record is saved. Simply follow your textbox assignment statement
with

Me.Dirty = False

and it'll remain locked.

 

[Pete]

Tested and verified.

Seems obvious when you put it like that.

Many thanks Linq