View Single Post
  #3  
Old July 22nd, 2009, 10:36 PM posted to microsoft.public.access.tablesdbdesign
Larry Daugherty
external usenet poster
 
Posts: 1,012
Default Event Procedure to lookup value in table and perform action based on value

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