<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4134.600" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial color=#0000ff size=2>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.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>I need to know how to keep the focus
on the control but kill the drop down.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Kath</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=papparuff@attbi.com href="mailto:papparuff@attbi.com">John Ruff</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, March 26, 2003 12:41
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Combo force drop
down UNDO</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=129343601-26032003><FONT face=Arial color=#0000ff size=2>In
the dropdown's AfterUpdate, set the focus to another
control.</FONT></SPAN></DIV>
<DIV><SPAN class=129343601-26032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=129343601-26032003><FONT face=Arial color=#0000ff
size=2>Private Sub TxtClientSurname_AfterUpdate()</FONT></SPAN></DIV>
<DIV><SPAN class=129343601-26032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=129343601-26032003> <FONT face=Arial
color=#0000ff size=2>LastName.setfocus</FONT></SPAN></DIV>
<DIV><SPAN class=129343601-26032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=129343601-26032003><FONT face=Arial color=#0000ff size=2>End
Sub</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><B><I><FONT face="Times New Roman" color=#0000ff size=4>John V.
Ruff</FONT><FONT face="Times New Roman" size=4> – </FONT><FONT
face="Times New Roman" color=#008080 size=4>The Eternal Optimist</FONT><FONT
face="Times New Roman" size=4></FONT> <FONT face=Wingdings color=#800080
size=4>J</FONT></I></B> <BR><I><FONT face="Times New Roman">Always Looking For
Contract Opportunities</FONT></I> </DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR><A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR><A
href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>