Read only access

[Nicolae Fieraru]

Hi All,

I am working on a database and I have a form which I use to view/enter data.
Most often the user needs to view data already entered and they can browse
through the records. Some of the data is displayed in a combobox and it is
very easy for the user to modify by mistake valid information. I would like
to put a checkbox on the form, or have a way of preventing the user to edit
the data unless they specificy they want to go into edit mode.

Any ideas appreciated.

Regards,
Nicolae

 

[John Vinson]

Hi All,

I am working on a database and I have a form which I use to view/enter data.
Most often the user needs to view data already entered and they can browse
through the records. Some of the data is displayed in a combobox and it is
very easy for the user to modify by mistake valid information. I would like
to put a checkbox on the form, or have a way of preventing the user to edit
the data unless they specificy they want to go into edit mode.

Set the Form's AllowEdits property to False; set it to True in the
Click event of a command button (and back to False in the form's
Current event or AfterUpdate event if you want to turn editing back
off when they leave the edited record).


John W. Vinson[MVP]

 

[Nicolae Fieraru]

Thank you John, that is very simple and useful to know.

Regards,
Nicolae