How do I close the current form when selecting a different option button. I tried to put docmd.close before opening the form but that only works one time and does not allow me to keep switching between forms. Goal:
Open form1, close form1 before opening form2.
open form2, close form2 before opening form3.
open form3, close form3 before opening form2.
and so on....
form1,2,&3 also have attached sub-forms.
If grpViewAll.Value = 1 Then
DoCmd.OpenForm "frmForecast1", acNormal, "qryAdd"
ElseIf grpViewAll.Value = 2 Then
DoCmd.OpenForm "frmForecast2", acNormal, "qryAdd"
DoCmd.OpenForm "frmForecast3", acNormal, "qryAdd"