clear check mark when field changes

[spcscooter via AccessMonster.com]

I have a field (Current CommTech Level) that changes from CommTech 2 to
CommTech 3 and so on. I also have 2 fields with checks marks in them, Passed
Written Exam and Passed Practical Exam. When the CommTech Level changes I
need the check marks to clear. We already have record of the testing process
off site, so keeping track of the testing process would be redundant over the
redunancy that is already in place.

Thank you for your help

 

[Rob Parker]

Hi Scot,

Use the AfterUpdate event of the control bound to the CurrentCommTechLevel
field, with code such as this:

Private Sub txtCurrentCommTechLevel_AfterUpdate()
Me.CheckField1 = False
Me.CheckField2 = False
End Sub

Change the field/control names to suit.

HTH,

Rob

 

[spcscooter via AccessMonster.com]

This is so frustrating. I have tried so many things to get this thing to
work and nothing. I tried the code in this thread and when I changed the
Current CommTech Level the two check boxes that I want cleared, didn't clear.
Calgon Take Me Away!!!

Thanks

Hi Scot,

Use the AfterUpdate event of the control bound to the CurrentCommTechLevel
field, with code such as this:

Private Sub txtCurrentCommTechLevel_AfterUpdate()
Me.CheckField1 = False
Me.CheckField2 = False
End Sub

Change the field/control names to suit.

HTH,

Rob

I have a field (Current CommTech Level) that changes from CommTech 2 to
CommTech 3 and so on. I also have 2 fields with checks marks in them,

[quoted text clipped - 7 lines]

Thank you for your help

--
Scot Rawlings
Technical Trainer
Comcast
Auburn, WA

Message posted via AccessMonster.com

 

[Rob Parker]

You might need a requery to refresh the form, thus:
...
Me.CheckField2 = False
Requery
...

Rob

This is so frustrating. I have tried so many things to get this thing to
work and nothing. I tried the code in this thread and when I changed the
Current CommTech Level the two check boxes that I want cleared, didn't
clear.
Calgon Take Me Away!!!

Thanks

Hi Scot,

Use the AfterUpdate event of the control bound to the CurrentCommTechLevel
field, with code such as this:

Private Sub txtCurrentCommTechLevel_AfterUpdate()
Me.CheckField1 = False
Me.CheckField2 = False
End Sub

Change the field/control names to suit.

HTH,

Rob

I have a field (Current CommTech Level) that changes from CommTech 2 to
CommTech 3 and so on. I also have 2 fields with checks marks in them,

[quoted text clipped - 7 lines]

Thank you for your help

--
Scot Rawlings
Technical Trainer
Comcast
Auburn, WA

Message posted via AccessMonster.com