Form Help

[RachelBedi]

I think this will be confusing but I'll to my best to explain.



I have a switchboard with various buttons to open various forms, when you click the button "Activations" it opens frmActivators - in the on load event of this particular form I have entered code;

Private Sub Form_Load()
If ([Bank Modified Date]) <= Date - 14 Then
DoCmd.Close acForm, "frmActivators"
DoCmd.OpenForm "frmOlderThanFourteen", acFormDS
End If
End Sub

If the user tries to close the form which opens they get booted from the database - the purpose of this is to force users to take care of any accounts that have passed 14 days and not bypass it.

Unfortunately in the on close of frmActivators I have code to open the switchboard again which means when the frmOlderThanFourteen opens so does the switchboard - which defeats my purpose of only allowing the user to access the one form frmOlderThanFourteen

I'm sure there is something simple to keep my switchboard from being open at the same time as this frmOlderThanFourteen form but I can't say I can find something.

Thank you guys for being so patient :-D

[RayMilhon]

Switch the order so that frmOlderThanFourteen opens before frmActivators closes. Also when you open the frmOlderThanFourteen open it modally.

[RachelBedi]

I knew it would be something simple LOL THANK YOU!