Steve

If you want to compare to the current date/time value, use the Now()
function Larry mentioned.

If you want to compare to only the current date portion, use the Date()
function.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Larry Daugherty" wrote in message
...
Compare [DLookup() the value in that table and field] with Now().

HTH
--
-Larry-
--

"steve" wrote in message
...
I have a table called dates that has only one row and one column
with
one date value. I want to write an event procedure on the Open
Event
of a form that looks the value in the dates table and, if the
current
date is greater than the value in the table, the form would close.

I am not sure what code or commands to use since I'm not that
familiar
with writing Event Procedures.

Any help would be appreciated.

Steve