"Owl" wrote in message
...
Thanks, Dirk. Here is the code for my Switchboard. Yes, I fiddled with
it
here and there, but I think it is back to what it was before (or at least,
more or less), except for the WarningsOn on Close.

Option Compare Database

Private Sub Form_Close()
DoCmd.SetWarnings (WarningsOn)

End Sub


That code is wrong, though, unless you have somewhere defined a global
variable named "WarningsOn". If your purpose is to turn warnings on, you
should write:


DoCmd.SetWarnings True

or

DoCmd.SetWarnings -1

However, if your switchboard is to remain open all the time the database is
open, I don't see any point in turning the warnings on while the database is
closing. I don't believe that command will have any effect when the
database reopens -- the warning settings at that time will be determined by
various option settings.

I have no idea whether the incorrect code in the Close event has any bearing
on your problem, I'm afraid.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)