Form controls

[newbieone]

I have a form that the user would like to be able to turn on and off the ability to edit. I have tried the properties window but it locks the whole form.

Here is the code I have tried but the trigger is not working to activate the code

Private Sub cmdEditform_Click()
Form.AllowAdditions = True
Form.AllowEdits = True
Form.AllowDeletions = True

it seems like the code is being ignored because even after I hit the locked button the form is still allowing edits.

 

[Remou]

'Me.' Might be better. I think you need a refresh:
[tt]Me.AllowAdditions = True
Me.AllowEdits = True
Me.AllowDeletions = True
Me.Refresh[/tt]

 

[TheAceMan1]

How are ya newbieone . . .

Forms!FormName.AllowEdits = True

or

Me.AllowEdits = True

See Ya! . . . . . .

 

[newbieone]

Both worked but for ease of code will use the Me.Allowedits and the me.refresh. thanks for the quick response.