• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 575
  • Last Modified:

Microsoft Access Me.Form.AllowEdits works too well

Access 2010  continuous form

I have added an option button to my access form.   See code below.   It works only once :)

What options do I have here.?

Private Sub OptAllowEdits_AfterUpdate()
       Me.Form.AllowEdits = OptAllowEdits
End Sub
0
peispud
Asked:
peispud
1 Solution
 
Bill RossCommented:
Hi,

Once you set a form property it stays that way until you set it differently or close and repoen the form to get the default property setting.

What do you want to happen?

Regards,

bill
0
 
mbizupCommented:
Are you trying to toggle it?

The click event of a label works well for this sort of thing:

Private Sub lblMyLabel_Click()

Me.AllowEdits = Not (Me.AllowEdits )
Me.lblMyLabel.Caption = iif(Me.AllowEdits = true, "Disable Edits", "Enable Edits")

End Sub

Open in new window

0
 
peispudAuthor Commented:
Yes,  I am trying to toggle.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now