Hi there,
I have been tasked with updating a bespoke Access Database which can open in either read only or read-write mode.
The mode is governed by a password. Entering the password gives full access, not entering the password causes this macro to run:
Form name Client information
View Form
Filter Name
Where condition ==”[Company Name]=Forms![Homer]![company search]”
Data mode read only
Window mode normal
So a missing/incorrect password opens a variant of the form which has featuring a command button with the above script.
There is a single field called Notes which I would like to make read/write when the rest of the database is read only. The field properties in the data tab are Enabled = Yes, Locked = No but the data mode in the macro overwrites this.
Is it possible to allow this field to be editable when the rest of the database is read only as per the macro?
Thanks in advance for your help