YES/NO Updates 1

[Athan]

Hello

I have one YES/NO field

and I want to log the yes and no value
in the following format

DateIN
DateOUT

so when there is on tick for yes
it will add a record for
the dateIN and will take the value of
current date & time [now()]
when the tick it again it will
update the dateOUT field again with now()

Thank you

Athan

 

[jflachman]

I'm not sure where your datein and dateout fields reside. Are they fields in the current form? If so, here is what you need to do.
In the After Update event for the checkbox, put the following code:
[tt]
If (CheckBoxName) 'It's now checked
Me![DateIN]=Now()
Else
Me![DateOUT]=Now()
End If
[/tt]

Does that help? If you're DateIN and DateOUT fields reside somewhere else, let me know where they are and I'll help w/code. Jonathan
________________________________________
It is not fair to ask of others what you are unwilling to do yourself.
-Eleanor Roosevelt