Close combobox after selection

[Autoeng]

I have a combobox on a form that takes a long time to populate when first selected so I coded the combobox's On Got Focus event to include

Me.MyComboBox.Dropdown

This works great but after selecting a record the combobox does not close even though the form fills appropriately. I have to click onto another field before the combobox will close.

What am I missing?

 

[___]

Maybe..

Me.AnotherControl.SetFocus

HTH

 

[Autoeng]

Ok I'll try that. How do I set focus to a field on a subform?

Forms![frmSubForm].[SubFormfield].SetFocus

Yes?

 

[___]

I think it'll be..

Forms![YourFormName]![YourSubform]![SubformField].SetFocus

HTH

 

[Autoeng]

Thanks. I'll give it a go.

 

[Rich]

You have to set focus to the subform first and then the field

 

[Autoeng]

Like so?...

Forms![MySybFrm].SetFocus
Me.MySubFrmField.SetFocus

What event would be best? I was thinking in the After Update of the combobox as the combobox never really loses focus.

 

[Rich]

You can only use Me.MyField if the combo is on the subform, otherwise you'll have to use the full forms reference

 

[Autoeng]

And what event Rich?

 

[Rich]

Is there some other code affecting the combo? Mine auto returns after selection or tabbing to another field, you'll have to try the AfterUpdate to see if it works, I've no way of testing it

 

[Autoeng]

Here is the code I placed in the After Update Event of the combobox.

Forms![frmVCBsf2].SetFocus
Forms![frmVCBsf2]![DueDateConfirmed].SetFocus

I am getting the error that "Cannot find form frmVCBsf2". Name is correct .

I tried to clairify the from first but still no luck

Forms![frmVCB]![frmVCBsf2].SetFocus
Forms![frmVCBsf2]![DueDateConfirmed].SetFocus

Anybody see what I am missing?

 

[Rich]

It's the name of the subform control as it appears on the property sheet you need, not as it appears in the db window

 

[Autoeng]

Just got it.

Forms![frmVCB]![frmVCBsf2].SetFocus
Forms![frmVCB]![frmVCBsf2]![DueDateConfirmed].SetFocus

For whatever reason I had to refer to the mainform in both lines.