Form dependent on date

[acarter1]

I am looking to display a form depending on the date.
What i have currently in a module is:

Option Compare Database
If Date = "23/12/2009" Or "23/12/2009" Or "24/12/2009" Then
DoCmd.OpenForm "frmSplashChristmas"
Else
DoCmd.OpenFrom "frmSplash"

Will this work if i run this module on the startup of the database as this did not work when it was on the form load of the frmSplash.
Thanks!

 

[pbaldy]

It would be

If Date = #23/12/2009# Or Date = #23/12/2009# Or Date = #24/12/2009# Then

You probably need to switch to US format for dates in code: 12/23/2009.