check box

[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

 

[Graham R Seach]

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