Form Advise

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

myxmaster@hotmail.com - 21 Mar 2007 17:55 GMT

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,?.

Reply to this Message

Douglas J. Steele - 21 Mar 2007 18:07 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Thanks for the reply Doug.
>
[quoted text clipped - 3 lines]
> allow no additions how will this work when I click the command button
> to add a record,?.

Reply to this Message