Me.MyCombo.Dropdown not responding

[GraeagleBill]

I have a code segment that runs when a form opens but the "DropDown" statement is ineffective. The RowSource looks good and with a default value set the combo appears with the default as expected but again the dropdown isn't working. What might be the cause of that?

Private Sub DonInit()

Me.AmtBox = Null
Me.AmtBox.Enabled = False       'Require designation of a fund

Me.cboFunds.SetFocus
Me.cboFunds.Dropdown

End Sub

[pbaldy]

What event is it called from? Perhaps it's too soon.

[GraeagleBill]

Good point, it was in the OnOpen event so I moved it to the OnActivate but still doesn't dropdown. Doesn't work from the OnCurrent either

Doesn't even work if I execute a dropdown when the control gets the focus.

[pbaldy]

I've used the got focus event before, never needed it when the form opens. Can you attach a sample db here?

[Micron]

Is it the only combo on the form? If so and the combo drops and retracts immediately (you may not be noticing it) then this is an old known issue - especially on form open event.
One work around is to call the form timer event from a combo event such as enter or gotfocus, set timer interval = 1, drop down the activecontrol, set timer to 0. Never tried it, but I think that's the general idea.

[GraeagleBill]

then this is an old known issue - especially on form open event

I didn't set a timer, rather, I added a MsgBox statement after the dropdown that would cause execution to pause. The dropdown in fact occurred as you had suspected. Is a permanent timer the solution to this caper?

[Micron]

Depends on your definition of permanent timer. My definition says no because the interval is set to zero after it runs, thus it may never run again - depending on what event called it. However, it will run again when the event you use to trigger it occurs again.

[Missinglinq]

The use of the timer is the definitive answer...which I'm guessing is what the OP meant by 'permanent.' As soon as the Messagebox is cleared, in his 'workaround,' the dropdown will again retract...not allowing anything to be done to it before doing so.

The code for this is super easy:

Private Sub Form_Open(Cancel As Integer)
  Me.TimerInterval = 1
End Sub

Private Sub Form_Timer()
  Me.TimerInterval = 0
  Me.ComboName.SetFocus
  ActiveControl.Dropdown
End Sub

Linq ;0)>

[GraeagleBill]

I'm guessing is what the OP meant by 'permanent.'

Yes

And yes, the timer does the trick. Also, if one makes the form a "Popup" the dropdown functions perfectly without the timer.

[Micron]

Thanks for the popoup tip