Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Sun Sep 21 21:48:48 CDT 2003
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 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030921/7d4e2d58/attachment-0001.html>