Check time Diff.

[wes028]

I have a field on the form that loads a start date and time.



I then set a variable to check the date and time right now. If that date and time is less then 5 min's from the start time. It will error.


How would you in do this in VBA to check if it's more then 5 min's have passed since the start time.

Thanks,

[pbaldy]

How about:

If DateDiff("n", YourFieldName, Now()) > 5 Then

[wes028]

thanks pbaldy,

Worked great. thanks for the help.

[pbaldy]

No problem, glad it worked for you.