<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<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>David - it sounds like your form is
quite similar. Are you forcing the drop down to display after the first 2 chars
are entered? That forcing of the drop down is what's mucking up the behaviour of
the combo.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>I have put this combo on the
very front menu (as there may be 20,000 clients), so that users can zero into
the record they want straight away. They then hit a 'Go' button to open the
appropriate client detail record. </FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>What's wrong with the drop down list
still being displayed? It *feels* like you haven't made a selection, because
normal combo behaviour would be:</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>1. Click on drop down arrow (or F4)
to see options.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>2. Click on an option.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>3. Option selected appears in
control.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>4. The drop down
disappears.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>When the 4th part doesn't happen
it goes against expected behaviour and is confusing.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>And because this combo has a wide
drop down (5 columns) it really is blocking the users from seeing other menu
options.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>They have to find a blank place on
the menu and click there to get rid of it.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>I could forget about forcing the drop
down, but as there is no record source until 2 chars are entered, it looks great
to enter 2 and then the list populated and displayed automatically.</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=DMcAfee@haascnc.com href="mailto:DMcAfee@haascnc.com">David
McAfee</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 2:19
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Combo force drop
down UNDO</DIV>
<DIV><BR></DIV>Kath, I have a very similar form which acts the same way. I
have to look up<BR>PNs and if I didn't limit the result set by not calling the
SPROC until I<BR>have at least two characters in my combo box, I'd have a lot
of PN's in that<BR>combo box!<BR><BR>Anyway, after I click on the combo, I (or
the user) clicks on another field<BR>or hits tab to leave the field, so the
combo at that points hides the drop<BR>down, so why go through the work of
trying to hide it? What does the user do<BR>next on your form after selecting
something from the box? Is there an OK<BR>button? I am just trying to
visualize what's going on.<BR><BR>D<BR>-----Original Message-----<BR>From: <A
href="mailto:accessd-bounces@databaseadvisors.com">accessd-bounces@databaseadvisors.com</A><BR>[mailto:accessd-bounces@databaseadvisors.com]On
Behalf Of Software Design &<BR>Solutions Pty Ltd.<BR>Sent: Tuesday, March
25, 2003 6:26 PM<BR>To: <A
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A><BR>Subject:
Re: [AccessD] Combo force drop down UNDO<BR><BR><BR>Thanks John. That would
work except that this is a combo that has no row<BR>source until the first 2
letters have been entered by the user. So the combo<BR>has an 'on change'
event which requires the control to have the focus.<BR>Moving the focus to
another control on the after update won't allow the on<BR>change to
occur.<BR><BR>I need to know how to keep the focus on the control but kill the
drop down.<BR><BR>Kath<BR>----- Original Message ----- <BR>From: John Ruff
<BR>To: <A
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
<BR>Sent: Wednesday, March 26, 2003 12:41 PM<BR>Subject: RE: [AccessD] Combo
force drop down UNDO<BR><BR><BR>In the dropdown's AfterUpdate, set the focus
to another control.<BR><BR>Private Sub
TxtClientSurname_AfterUpdate()<BR><BR>
LastName.setfocus<BR><BR>End
Sub<BR>_______________________________________________<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:
<A
href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</A><BR></BLOCKQUOTE></BODY></HTML>