HELP, How to pass field value of Time to vba code?

[Labadore]

I have a field that stores the current time when a cmd button is clicked. I am trying to reference that value in VBA in order to check if the time has passed 12:00 Am or greater than 12:00 AM. This is a timesheet program I have worked on that is almost complete. The only problem I have come across is when someone works overtime and happens to work past 12:00 Am it doesn't add twelve to the total. That is a time/date field.

If (field variable) >= (12:00 Am ?) then
etc...

if anyone knows how to possibly help me with this I would greatly appreciate it. Thank you in advance for your time and knowledge.

Labadore

 

[Aivars]

If me.txtTime >= #12:00 AM# then
do ......
End If

Aivars