<!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 6.00.2600.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<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></BODY></HTML>