Auto Populate Field with Date

[spaceherpe61]

I am looking to populate a field named "Date Called" with the current date. Based on a Yes/No named "Called" changing from No to Yes. I have tried a few different attempts at modules, but none of them seem to be working. Any suggestions would be greatly appreciated.

 

[PaulF]

In the AfterUpdate Event for the Called Yes/No Control, add

If CalledControlName = True Then
DateCalledControlName = Format(Date(),"mm/dd/yyyy")
End If

PaulF

 

[batteam]

Assuming the Yes/No field is a checkbox control on your form called chkYesNo and the field you want to show the current date is textbox called txtDateCalled, you could put this in the click event of chkYesNo:

If chkYesNo.Value = true then
txtDateCalled = Date()
Else
End if

You can expand on this code by having txtDateCalled put to another date if the user 'unchecks' chkYesNo, i.e. chkYesNo.Value = False.

Hope this helps.

 

[ZmrAbdulla]

See thread702-1043484

________________________________________
Zameer Abdulla
Visit Me
There is only one perfect child in this world. Every mother has it.