[AccessD] Combo - dropdown - Force top of list with each

Tortise@Paradise tortise at paradise.net.nz
Sun Sep 21 22:04:06 CDT 2003


Kewl thanks Rocky, that was the trick.  (This one: cboBox=cboBox.ItemData(0) )
Box not bound, so not an issue.
Kind regards,
David Hingston

----- Original Message ----- 
  From: Rocky Smolin - Beach Access Software 
  To: Access Developers discussion and problem solving 
  Sent: Monday, September 22, 2003 2:48 PM
  Subject: Re: [AccessD] Combo - dropdown - Force top of list with each


  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.

  But remember if it's a bound combo box, you'll be changing the value of the underlying record.

  Rocky Smolin
  Beach Access Software

    ----- Original Message ----- 
    From: Tortise at Paradise 
    To: accessd at databaseadvisors.com 
    Sent: Sunday, September 21, 2003 6:59 PM
    Subject: [AccessD] Combo - dropdown - Force top of list with each


    Hi
    Has anyone figured out a way to force a dropdown to start top of the list?
    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.
    Requerying does not change this positioning.
    (The example I have is set to maximum number of rows screen will allow, of course, and the list is longer than this.)
    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)
    TIA
    Kind regards,
    David Hingston



----------------------------------------------------------------------------


    _______________________________________________
    AccessD mailing list
    AccessD at databaseadvisors.com
    http://databaseadvisors.com/mailman/listinfo/accessd
    Website: http://www.databaseadvisors.com



------------------------------------------------------------------------------


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030922/c90ae606/attachment-0001.html>


More information about the AccessD mailing list