combo dropdown

[robart6]

I have a form with a combo box dropdown. The After Update property of the combo box opens a second form to the record matching the name selected on the first form combo box dropdown. This works fine when selecting the name by pressing Enter but when the user selects the name by mouse clicking it, the second form opens and the dropdown list is visible. How do I make the dropdown list go away when the second form opens?

 

[DazedandMuddled]

How do I make the dropdown list go away when the second form opens?

don't exactly know if this is what your looking for but couldn't you use the

Private sub After update_click()

DoCmd.Close acForm, "Form" 'to close form 1

--then your command to open the second form

end sub


but if you've got it on a subform - then i'm afraid i don't know

HTH

Cam

 

[dcx693]

don't exactly know if this is what your looking for but couldn't you use the

Private sub After update_click()

DoCmd.Close acForm, "Form" 'to close form 1

--then your command to open the second form

end sub

HTH

Cam

Wouldn't that particular order of operations close the 1st form before the command to open the 2nd form ever got executed?

 

[DazedandMuddled]

Wouldn't that particular order of operations close the 1st form before the command to open the 2nd form ever got executed?

Ops yea my bad -
if the code for the opening 2 form was first then that code (that better )

thats a better order - thanks for the brain nudge