Check that the date entered is the current date

A

allie

I need to give a message if the date entered is not the
current date.
I wrote:
if txtdate <> date then
msgbox "the date entered is not today's date
end if

txtdate = name of date field on form
date = date function

It does not work. It is taking the date entered in
txtdate and assigning it to date.

please help

Thanks
 
E

eob

Why not just make today's date the default and not allow the user to enter anything in the date field?
 
A

Allie

I thought of that but the date in the field does not
always have to be the current date, and the users do not
want to always have to delete. They prefer a prompt.

-----Original Message-----
Why not just make today's date the default and not allow
the user to enter anything in the date field?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top