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>