[AccessD] Combo force drop down UNDO

Kath, I have a very similar form which acts the same way. I have to look up
PNs and if I didn't limit the result set by not calling the SPROC until I
have at least two characters in my combo box, I'd have a lot of PN's in that
combo box!

Anyway, after I click on the combo, I (or the user) clicks on another field
or hits tab to leave the field, so the combo at that points hides the drop
down, so why go through the work of trying to hide it? What does the user do
next on your form after selecting something from the box? Is there an OK
button? I am just trying to visualize what's going on.

D
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Software Design &
Solutions Pty Ltd.
Sent: Tuesday, March 25, 2003 6:26 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Combo force drop down UNDO


Thanks John. That would work except that this is a combo that has no row
source until the first 2 letters have been entered by the user. So the combo
has an 'on change' event which requires the control to have the focus.
Moving the focus to another control on the after update won't allow the on
change to occur.

I need to know how to keep the focus on the control but kill the drop down.

Kath
----- Original Message ----- 
From: John Ruff 
To: accessd at databaseadvisors.com 
Sent: Wednesday, March 26, 2003 12:41 PM
Subject: RE: [AccessD] Combo force drop down UNDO


In the dropdown's AfterUpdate, set the focus to another control.

Private Sub TxtClientSurname_AfterUpdate()

    LastName.setfocus

End Sub