Clearing the field when box unchecked

  • Thread starter Thread starter Alex via AccessMonster.com
  • Start date Start date
A

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
 
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>
 
Back
Top