I am getting stumped with System date. I have seen many variant examples but still could not figure why I am still getting my form “frmPassword” opened instead of frmSwitchboard. What I wanted to do is to open the frmSwitchboard if the system date is less than 31/03/2011. The other thing is that whenever I type 31/03/2011 it changes to 31/3/2011 but I think it should not affect the condition. Can someone please help?
Private Sub Form_Load()
If Date < "#" & 31 / 3 / 2011 & "#" Then
If Me.Ntimes > 2 Then
ElseIf Me.PFlag = "+" And Me.Ntimes < 3 Then
DoCmd.Close acForm, "frmStart"