Clearing the field when box unchecked

[Alex via AccessMonster.com]

Hi
I have a checkbox, when checked a form will pop up which the user has to
fill in and then close, ect (not important)
Next to the check box there is a field which populates after the second
form is filled in. I need to make it that way so when the box is unchecked
the field next to it will clear up again.
Sorry if I coudn't simplify my post. It seems easy to do I just can't get
the right VB code
Any help would be welcomed
Thanks

 

[Jeff Boyce]

Alex

One approach would be to add code to the AfterUpdate event of the checkbox
that "empties" the adjacent textbox. ?Perhaps something like:

If Me!chkMyCheckBox = False Then
Me!txtMyAdjacentTextBox = Null
End If

Good luck

Jeff Boyce
<Access MVP>

 

[Alex via AccessMonster.com]

Works great! Thanks Jeff