Program Deactivation

[roycunderwood]

Hi everyone, I have a need to deactivate a msaccess app after a certain date (table lookup field). How can I modify which startup form based on date?

Thanks !

[janders468]

One way to do this, although it could it be defeated by someone who knew what they were doing, is create a function that is run from the autoexec macro. For Example

If Now > then SOMEDATE then
   docmd.openform "Relevant Form"
Else
   docmd.openform "Other Form"
end if

[roycunderwood]

Well Thank you! That worked!