Form Advise

M

myxmaster

Thanks for the reply Doug.

Would I do this with 3 seperate command buttons?, if not I am unaware
of the code required. If I do use command buttons how does this work
with setting the properties for the form. I mean if I set the from to
allow no additions how will this work when I click the command button
to add a record,?.
 
D

Douglas J. Steele

I'm suggesting that you have a button that resets the form's properties. A
toggle button might be best: allow changes when it's depressed, and don't
allow them when it's raised.

In your form's Load event, you'd put code like:

Me.MyToggleButton = False

In the toggle button's Click event, you'd put code like:

Private Sub MyToggleButton_Click()

Me.AllowAdditions = Me.MyToggleButton
Me.AllowDeletions = Me.MyToggleButton
Me.AllowEdits = Me.MyToggleButton

End Sub
 
Top