DWUTKA at marlow.com
DWUTKA at marlow.com
Thu Apr 15 15:45:06 CDT 2004
In the section that you 'want', what is the difference between DSC M and DSC M? Why would you want 2, when you have 1 of everything else? Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Hewson Sent: Thursday, April 15, 2004 2:53 PM To: AccessD Subject: [AccessD] Sorting and restricting ComboBox on ListBox contents I am having difficulty figuring this one out. A97. I have a list box with over 130 items all rows are distinct but a few columns are duplicates. The ListBox is sorted on two text fields which puts the ID number out of sequence. The ComboBox sorts and "Groups By" duplicate columns. What I want to do is use the ComboBox to jump to the first instance of one of the duplicate columns. e.g. ID CourseName City 135 CCP EC 90 DIS EC 87 DIS MP 18 DOC CD 17 DOC SR 55 DSC M AL 57 DSC M EC 43 DSC M MP 28 DSC M SF 3 DSC M SR What I want is: 135 CCP EC 90 DIS EC 18 DOC CD 55 DSC M AL 3 DSC M SR What I get is: 135 CCP EC 87 DIS MP 17 DOC SR 3 DSC M SR What needs to be done to what the desired results? Thanks, Jim