rollup dropdown

[Wendy]

Hi, I have a combobox dropdown with an onchange eventt. one of the selections
opens a popup form using the afterupdate event. while the popup form is open
the combobox stays in the dropdown state. How can I prevent this, ie I need
the combobox to close (rollup)when the popup is open.

Thanks

 

[fredg]

Hi, I have a combobox dropdown with an onchange eventt. one of the selections
opens a popup form using the afterupdate event. while the popup form is open
the combobox stays in the dropdown state. How can I prevent this, ie I need
the combobox to close (rollup)when the popup is open.

Thanks

Why are you using the Change event? That fires each time you enter a
character in the control. Is that what you want?

I can't duplicate that behavior, so perhaps you have something else
going on.
Try setting focus to another control just before you open the pop-up
form.
[OtherControl].SetFocus
DoCmd.Openform etc...

 

[Wendy]

You were right something else was going on and I fixed the problem. Also I'm
using the on enter event to open the list instead of onchange.
thanks

Hi, I have a combobox dropdown with an onchange eventt. one of the selections
opens a popup form using the afterupdate event. while the popup form is open
the combobox stays in the dropdown state. How can I prevent this, ie I need
the combobox to close (rollup)when the popup is open.

Thanks

Why are you using the Change event? That fires each time you enter a
character in the control. Is that what you want?

I can't duplicate that behavior, so perhaps you have something else
going on.
Try setting focus to another control just before you open the pop-up
form.
[OtherControl].SetFocus
DoCmd.Openform etc...