<!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><FONT face=Arial size=2>Kewl thanks Rocky, that was the trick. (This
one: cboBox=cboBox.ItemData(0) )</FONT></DIV>
<DIV><FONT face=Arial size=2>Box not bound, so not an issue.</FONT></DIV>
<DIV>Kind regards,<BR>David Hingston</DIV>
<DIV> </DIV>
<DIV>----- Original Message ----- </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=bchacc@san.rr.com href="mailto:bchacc@san.rr.com">Rocky Smolin -
Beach Access Software</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers discussion and
problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, September 22, 2003 2:48
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] Combo - dropdown -
Force top of list with each</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>I think it's returning to the previous value
because it still 'remembers' the last value selected. So if you get the
first value in the combo box and set the combo box to that value the do the
dropdown, that should work. In fact (without testing) I think
cboBox=cboBox.ItemData(0) might do it.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>But remember if it's a bound combo box, you'll be
changing the value of the underlying record.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rocky Smolin<BR>Beach Access
Software</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 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=tortise@paradise.net.nz
href="mailto:Tortise@Paradise">Tortise@Paradise</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> Sunday, September 21, 2003 6:59
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [AccessD] Combo - dropdown -
Force top of list with each</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Hi</FONT></DIV>
<DIV><FONT face=Arial size=2>Has anyone figured out a way to force a
dropdown to start top of the list?</FONT></DIV>
<DIV><FONT face=Arial size=2>When one opens a new form / dropdown it is
there, but if you move down the list to take the top line off the screen,
when you subsequently re-enter the combo it resumes at the level you
left.</FONT></DIV>
<DIV><FONT face=Arial size=2>Requerying does not change this
positioning.</FONT></DIV>
<DIV><FONT face=Arial size=2>(The example I have is set to maximum
number of rows screen will allow, of course, and the list is longer than
this.)</FONT></DIV>
<DIV><FONT face=Arial size=2>I want to force everytime it is entered to
dropdown and start top of the query list. (That is the scroll bar is
repositioned to the top of the list also)</FONT></DIV>
<DIV><FONT face=Arial size=2>TIA</FONT></DIV>
<DIV>Kind regards,<BR>David Hingston<BR></DIV>
<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>
<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>