G Guest Dec 11, 2005 #1 Can anyone tell me the correct coding to close all open forms except the active form?
M Marshall Barton Dec 11, 2005 #2 PRH said: Can anyone tell me the correct coding to close all open forms except the active form? Click to expand... For k = Forms.Count - 1 To 0 Step -1 If Forms(k).Name <> Me.Name Then DoCmd.Close acForm, Forms(k).Name, acSaveNo End If Next K
PRH said: Can anyone tell me the correct coding to close all open forms except the active form? Click to expand... For k = Forms.Count - 1 To 0 Step -1 If Forms(k).Name <> Me.Name Then DoCmd.Close acForm, Forms(k).Name, acSaveNo End If Next K