Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Sep 2004
    Location
    Wolverhampton, Staffordshire, England
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Attempting to sort a combobox (2000)

    Hey there, i am creating an incident report databse for a school, consiting of 2 tables, pupils and incidents, in the incidents table you can select the pupil ID that has been involved in the incdent via a combobox (on userform), my problem is that the list is ordered by the pupil ID and i need to to be roedered by Surname, Surname and Forename are two seperate fields so i cannot use Surname as the key, i am only a novice at Access so any solution would be helpful, many thanks
    Danny D

  2. #2
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Attempting to sort a combobox (2000)

    Danny,
    Right click on your combo box, and then go to Data: Row Source, and click on the little |...| In the query design view, you can specify your sort, if your columns aren't in the order that you want your sort to happen, add them to the query design view in the order you want them to sort, uncheck the box, and then sort ascending: In the example, notice Home Phone is on there twice. Hopefully that illustrates the instructions. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  3. #3
    Star Lounger
    Join Date
    Sep 2004
    Location
    Wolverhampton, Staffordshire, England
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Attempting to sort a combobox (2000)

    that's perfect thanks [img]/forums/images/smilies/happy.gif[/img]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •