automatically open cbo

[Jerry]

From cboBoxA in formA I go to formB. When I close formB I would like to have cboBoxB in formA dropdown automatically. FormA does not close when I go to formB
I’ve tried this in formA
Private Sub cboBoxB_GotFocus()
Me.cboBoxB.Dropdown


End Sub

I have searched and tried other solutions but can't get it to work.

[RuralGuy]

What means do you use to get "From cboBoxA in formA I go to formB"?

[Jerry]

I have cascading cbo's and in the last one, cboBoxA, I select an item that refers to a specific form, formB. There are multible forms to go to depending on what is selected in cboBoxA but I only want formB to dropdown cboBoxB in formA when formB is closed. I have tried working from the OnClose in formB. FormA remains open when I go to formB.

I use Select Case in the cbo After Update Event Procedure

[RuralGuy]

Do you open FormB with the acDialog argument?

[Jerry]

This is how it is opened. It is one "case" out of 13.

Select Case cboBoxA.Value
Case "FormB"
DoCmd.OpenForm "FormB", , , "Pattern = '" & Me.cboPatterns & "'"

[RuralGuy]

And if you changed that to:
DoCmd.OpenForm "FormB", , , "Pattern = '" & Me.cboPatterns & "'", ,acDialog
Me.cboBoxB.SetFocus
Me.cboBoxB.Dropdown
...FormB would open Modal and the code in FormA would stop until FormB was closed or made invisible.

[Jerry]

Well it almost worked. When I closed formB I see formA but it is not active. Click anywhere on formA to activate and cboBoxB does have focus but it is not dropdown.

Also if I have another program running when I close formB I am taken out of Access and into the other program?

[Jerry]

Ok got to work. The code you suggested worked I just had to split it up and get it in the right spot. Stopping the code until formb closed was correct but setting the focus and dropdown had to be inserted after other events took place. I also had a control button to close formb. When I use the control button focus works but not the dropdown. When I use the X, top right hand corner, it all works fine. The issue of other programs running has been resolved. It only happened when I was trying to find the right spot to insert the code.

Thank you RuralGuy.

[RuralGuy]

Glad we could help.