Allow edit control box

[simonblanco]

Hi everyone, it's my first post here. I use macros on excel quite often, but with Access i'm totally lost....

My question: I have a starting form from where you can move between other forms. I want a button on the starting form (a control box?) that you click and able/disable editing (by default disabled) in the whole database (access2007).

I have seen i must use:

Me.AllowEdit = True / False

but differently than excel i am not sure where i must put that code, and how i can link it to the button. If you can be quite detailed i'll be very grateful... Thanks in advance!!!

 

[Galaxiom]

Set a value of a global variable (Boolean type) using the button click procedure on the startup form.

A Global variable is a Public variable declared in a Standard Module in the VBA project for the database. It is available throughout the VBA project.

In the Load event of each form test for the variable and enable or disable edits in the form. See the form's On Load event property, press the ... button and choose Code Builder. Enter the command into the procedure.