check box

  • Thread starter Thread starter Duke
  • Start date Start date
D

Duke

I have a "date returned" field on my form and I need a
checkbox (tick on and off) that when in the off position
will clear the contents of the "date returned" field.
I need the check box to revert to "on" on the next record
so that it is ready for the next entry. The database is a
Video Collection Lirary for my University project.
thanks Duke
 
Duke,

1. If the checkbox is bound, set its DefaultValue property to True. If it
isn't bound, add the following code to the form's Current event:
Me!chkMyCheckBox = True

2. In the checkbox's AfterUpdate event, add the following code:
If Not Me!chkMyCheckBox Then
Me!txtDateReturned = ""
End If

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