How do I close a combobox after using dropdown command 1

[dawnd3]

Hi again,

I have I have a combobox that uses the activeform.dropdown command to automatically open when user enters the feild. However, there is also a NotInList event that triggers a message to add the item when new. When this message comes up the combobox list is covering the message and there is just a peice of it sticking out so that I can click yes and add my item. However, I don't think the user will like this feature Is there a way to tell the dropdown to close back up? This is in Access 2000. Thanks, your expert and novice Dawn

http://www.calliopeconsulting.net

 

[Jn88]

It's a trick !
cmb.Enabled = False
cmb.Enabled = True
Hope this helps if not let me know

Jn88
Jn88@att.net

 

[dawnd3]

Oops I meant to say that the command is
Activecontrol.dropdown
I put this in the onKeyPress event

So how do I apply your suggestion?
Activecontrol.dropdown = false ???

I already tried that and it didn't work. Am I doing the syntax correctly?

Thanks for your help.

Dawn

http://www.calliopeconsulting.net

 

[Jn88]

I said “it is a trick” there is actually no way of closing the combo box but by sating the combo box enabled property to false and then back to true it will close itself, I hope you get it. Hope this helps if not let me know

Jn88
Jn88@att.net

 

[dawnd3]

I am sorry if I am being an airhead here...but do I replace my code with your suggested code or do I add it. And what event should I place this code? Thanks again. Dawn

http://www.calliopeconsulting.net

 

[Jn88]

Send me your email address and I will sand you an example attachment Hope this helps if not let me know

Jn88
Jn88@att.net

 

[dawnd3]

dawnd3@yahoo.com

thank you!

http://www.calliopeconsulting.net