Software Design & Solutions Pty Ltd.
SDSSoftware at Optusnet.com.au
Tue Mar 25 20:25:35 CST 2003
MessageThanks 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
John V. Ruff - The Eternal Optimist J
Always Looking For Contract Opportunities
------------------------------------------------------------------------------
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030326/2e86c881/attachment-0001.html>