check box to contol text box

mkelly

Registered User.
Local time
Today, 14:18
Joined
Apr 10, 2002
Messages
213
I have a form with a check box that is checked when a file is returned. How can I make it so once the check box is checked it will auto fill the date in a text box called "date Returned"?

thanks in advance
 
In the AfterUpdate event of the checkbox
If Me.chkBox Then
  Me![dateReturned]=Date()
End If

where chkBox is the name of your checkbox.
 
I tried this but I get an error that the macro ifme does not exsist?
Any suggestions
 

Users who are viewing this thread

Back
Top Bottom