Results 1 to 4 of 4
  1. #1
    NateL is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2013
    Posts
    11

    Sort Multiple Fields in a Split form

    I have a split form with 10-15 fields. Each of these fields is a combo box. The trouble I am having is sorting the data in the datasheet of the split for. I want to sort ascending by "ProductTypeName", then ascending by "Parent SKU" and then ascending by "ProductSizeID".

    How can I do this when each of my combo boxes have an ID and then a name? Example below:


    ProductTypeID ProductTypeName
    1 Apron - Bib
    2 Apron - Waist
    3 Bag - Backpack
    4 Chef Coat
    5 Crewneck
    6 Fleece - Glove
    7 Fleece - Jacket
    8 Fleece - Vest
    9 Oxford
    10 Pharmacy Coat
    11 Polo
    12 Poplin
    13 Twill
    14 Vest - Ladies'
    15 Vest - Men's
    16 Yoga Mat
    17 Apron - V-Neck



    ID Parent SKU
    3 BIG900
    4 BIG927
    5 BIG932
    6 DAQ108
    7 DAQ112
    8 SAL105
    9 SIZ105
    10 SNS106
    11 BFT1157
    12 BIG982
    13 FDS531
    14 ALS122
    15 DAQ110
    16 JWL159
    17 AMT196
    18 AMT197
    19 AMT198
    20 AMT199
    21 AMT200
    22 AMT201
    23 AMT202
    24 AMT203
    26 PKB119
    28 EBC122
    29 EBC123
    30 EBC124
    31 EBC125
    32 EBC126
    34 JWL160

    ProductSizeID Size
    1 XXS
    2 XS
    3 SM
    4 MD
    5 LG
    6 XL
    7 2XL
    8 3XL
    9 4XL
    10 5XL
    11 6XL
    12 7XL
    13 8XL
    14 9XL
    15 LGT
    16 XLT
    17 XXLT
    18 3XLT
    19 4XLT
    20 5XLT
    21 6XLT

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    Is the record source a query? If so, then sort via your query.

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    What method are you using to sort?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    NateL is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2013
    Posts
    11
    I was able to accomplish this by updating the Order By within the Form properties.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 04-24-2014, 10:02 AM
  2. Split form Datasheet Sort from A to Z
    By data808 in forum Forms
    Replies: 3
    Last Post: 03-30-2014, 12:43 AM
  3. Replies: 3
    Last Post: 01-08-2013, 02:41 PM
  4. Code to sort data shown on a split form
    By meissnerb in forum Programming
    Replies: 1
    Last Post: 05-03-2012, 04:34 PM
  5. Replies: 1
    Last Post: 03-12-2012, 02:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums