Barbara Ryan
BarbaraRyan at cox.net
Fri Aug 19 13:51:50 CDT 2005
I have used the following code successfully in Access 97 to close all forms when a specific function key is pressed. However, in Access 2002, this code causes the error box to appear (with the 2 options to send an error report to Microsoft or not) and then closes Access. Does anyone know why? Function CloseAllForms() Dim i As Integer ' Loop through the collection of open forms and close them (except for the main menu) If Forms.Count > 0 Then For i = Forms.Count - 1 To 0 Step -1 If Forms(i).Name <> "frmMainMenu" Then DoCmd.Close acForm, Forms(i).Name End If Next i End If End Function Thanks, Barb Ryan