after disable on check how do you enable after double click

gigifarrow
gigifarrow used Ask the Experts™
on
I want to disable a field when its clicked but if they make a mistake i want to be able to double clicl to enable but it doesnt work. what do i need to do to make this haappen ? I also want to make it turn a colorvwhen its disabled where would i do that in the code? herenis what i have so far.


Private Sub Induction_Click()
Me.Induction.Enabled = False
background color= red
End Sub

Private Sub Induction_DblClick(Cancel As Integer)
Me.Induction.Enabled = True
End Sub
bingo.accdb
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
I added a command button to reset the induction check box. Once you disable it, double-clicking it will not work.

Flyster
bingo.accdb

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial