[MS_AccessPros] How to refresh the button

 

Dear All,

I have a button on a form, it is supposed to lock the form. My problem is right after clicking on it. the form still can be edited. Only if I move to a text box and click enter, then the form is locked. How can I get the lock effect right after running the command button? Please Help.Thanks!

My code is here:

Private Sub Command424_Click()
If Me.Checked=True Then
Me.AllowEdits =False
ElseIf Me.Checked=False Then
Me.AllowEdits =True
End If
End Sub

Best Regards,
Kevin

__._,_.___

---

Posted by: Qingqing <qingqinga@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___