Creating a time limited form

[ypper2001]

I need to create a time limited form, here is an example:
In a table (Time_To_Show) I have stored the foloving info:
Form show from: 23.12.2007
Form Show to: 01.01.2008

I need to write a code that displays this form (Time_To_Show_Form) between this two dates.
How would I achieve this?

Thanks for any help with this.

[missinglinq]

That displays the form where/when? And what do you want to happen after the "expiration" date?

[ypper2001]

I would like the form to open when entering one other form, lets say you open the form Orders. If the date is between the ones mentioned above it would open over the other form as a notice. I would connect the code to the happening "on open" in the form Orders

After the date has past (Form Show to: 01.01.2008) this form would not open again until I have changed the dates in the table (Time_To_Show).

It`s a little hard to explain because my english is not that good, but I hope you got it.

[ypper2001]

No one that can help?

[jamjar]

In a table (Time_To_Show) I have stored the foloving info:
Form show from: 23.12.2007
Form Show to: 01.01.2008

I need to write a code that displays this form (Time_To_Show_Form) between this two dates.
How would I achieve this?

You could use DLookup in your On Open event code to check the current date against the dates in your table

Dim dtStart As Date
Dim dtEnd As Date
dtStart=DLookup("[ Form show from]","Time_To_Show","")
 dtEnd=DLookup("[ Form show to]","Time_To_Show","")
If Date >= dtStart And Date<=dtEnd Then
   DoCmd.OpenForm "Time_To_Show_Form"
End If
 

I think this would work for you ...
If this is a one off, why not just put the dates straight in the code?

James

[ypper2001]

I think this would work for you ...

James

Yes it did and thank you for helping out!
Best wishes from the land of the midnight sun.