Hi everyone,
I am struggling with what I thought would be easy to accomplish and was hoping for some assistance.
I have a form with a field called FirstAttempt which is a checkbox. I also have a date and time field (was asked to separate these). I can get the date to populate once the box is checked but, I cannot get the time to populate in the time field. I was trying to use a VBA If/then statement using date() and time(). Can you not use an AND in the If/then?
The code I tried was based on an OnClick event:
If me.FirstAttempt=true then
Me.attempdt=date AND me.attempttm=time()
End if
Is there a better solution other than this to accomplish what I need? Thank you for any help!