<!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>Glad to hear that I'm not the only
one with this problem....your code and mine give me exactly the same result, so
I'll have a think about your last suggestion with the text box. </FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Add to wishlist: </FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Ctrl.dropdown = false</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:40
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Combo force drop
down UNDO</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=459012803-26032003><FONT face=Arial color=#0000ff
size=2>Yup:</FONT></SPAN></DIV>
<DIV><SPAN class=459012803-26032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=459012803-26032003><FONT face=Arial color=#0000ff
size=2>Private Sub cboPN_Change()<BR>If Len(Me.cboPN.Text) < 2
Then<BR> Me.cboPN.RowSource =
""<BR>Else<BR> Me.cboPN.RowSource = "EXEC stp_007A_FillcboPN
'" & Me.cboPN.Text & "'"<BR>
Me.cboPN.Dropdown<BR>End If<BR>End Sub</FONT></SPAN></DIV>
<DIV><SPAN class=459012803-26032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=459012803-26032003><FONT face=Arial color=#0000ff size=2>I
would have went bigger, but we actually have 2 digit PN's
:(</FONT></SPAN></DIV>
<DIV><SPAN class=459012803-26032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=459012803-26032003><FONT face=Arial color=#0000ff
size=2>Anyway, I finally got aggravated enough that I went back to my old plan
of having the user enter the PN into a text box and calling a SPROC in the
after update event of the text box. If the PN doesn't exist, then I give them
a nice ol' MsgBox and clear out the field :) I figured that since the
form is unbound, I can disable the [OK] button until all fields have good data
in them ;)</FONT></SPAN></DIV>
<DIV><SPAN class=459012803-26032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=459012803-26032003><FONT face=Arial color=#0000ff
size=2>Another thing you can do, if you don't get this working, is to switch
to a text box and make an non visible list box appear under the text box, then
on select (of the LB), populate the text box and hide the
lb!</FONT></SPAN></DIV>
<DIV><SPAN class=459012803-26032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=459012803-26032003><FONT face=Arial color=#0000ff
size=2>HTH</FONT></SPAN></DIV>
<DIV><SPAN class=459012803-26032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=459012803-26032003><FONT face=Arial color=#0000ff
size=2>David McAfee</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Software
Design & Solutions Pty Ltd.<BR><B>Sent:</B> Tuesday, March 25, 2003 7:21
PM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> Re:
[AccessD] Combo force drop down UNDO<BR><BR></FONT></DIV>
<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</BLOCKQUOTE></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>