Help with code

[Martin]

I need some help with writing some code. I have a checkbox
on my form called "chkYes", and two text boxes
named "txtSITE1" and "txtSITE2" what I want is if the user
checks the checkbox and txtSITE1 does not
equal "California" then I want the textbox in "txtSITE2"
to become null. I would appreciate anyones help with this!

Thanks,
Martin

 

[Graham R Seach]

Martin,

Private Sub chkYes_Click()
If (Me.chkYes = True) And (Me.txtSITE1 <> "California") Then Me.txtSITE2
= ""
End Sub

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html