Access 2007: Dropdown Help

Hi
I need some help on this one. I have a drop down box. As soon as I start typing in it, it drops down automatically using (ActiveControl.Dropdown) on key press event procedure. when i press enter to select the client the dropdown box stay open and does not close. What can I put into the "on enter" event to close the drop down box after I press enter.
I have tried to set the focus to something else on enter but it does not work.
Please let me know if you guys have any ideas.
Thank you very much

 

I think that the code that you have in the key press event is causing your problem, why do you need it?

 

as soon as I start typing a name the drop down drops automatically i see which client im picking and I click enter the client is loaded but the dropdown stay open which is very annoying.

 

Try deleting the VBA code in the key press event procedure.