Option Group - Blank Choice

  • Thread starter Thread starter Jani
  • Start date Start date
J

Jani

I have an option group which works correctly to open up several different
forms. The problem is that if I open up FormA, close FormA and am then back
to the main switchboard, I can't again open up FormA immediately; must open
up FormB (or whatever), close FormB, then can open FormA again. What am I not
doing? I've tried requery with no success. Thanks in advance for your help.
Jani
 
It is really hard to say without know how you open formA using the options
group.
What is the flow of data/actions are you using?
When you return to the switchboard are you closing formA or just placing
focus on the switchboard?
 
First part of my query - How you open formA using the options group. What is
the flow of data/actions are you using?
 
Sorry - following code opens the FormA (or the one chosen):
Private Sub MainSwitchboard_AfterUpdate()
Dim strFormName As String

Select Case Me.MainSwitchboard
Case 1
strFormName = "frm_CMMS_NonPMTasks"
Case 2
strFormName = "frm_CMMSPrevMaintTable"
Case 3
strFormName = "frm_CMMS_PMTaskList_AddNew"
Case 4
strFormName = "frm_CMMS_PMTaskList_Maintenance"
Case 5
strFormName = "frm_CMMSMainForm_PMTasks"
Case 6
strFormName = "frm_CMMS_Reports"
End Select

DoCmd.OpenForm strFormName
End Sub
 
Back
Top