rollup dropdown

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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...
 
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

fredg said:
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
Click to expand...

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...
Click to expand...
 
Back
Top