Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    accesstos's Avatar
    accesstos is offline Expert
    Windows XP Access 2007
    Join Date
    Dec 2018
    Location
    Greece
    Posts
    551
    Quote Originally Posted by skydivetom View Post
    is there a way the VBA can be tweaked to sort them in ASC order regardless of which is the last/current role?
    Tom, always there is a way!...

    In Form's Load event procedure, you will find this line of code:
    Code:
    'Fill the listbox with the related functions/roles.
        Me.lstRoles.RowSource = "SELECT roleIDpk, roleName From tlkpRoles WHERE BilletIDfk=" & mvArgs(2) & " ORDER BY roleName"
    You have to add the bold part.



    Cheers,
    John

  2. #17
    skydivetom is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Feb 2019
    Posts
    1,038
    Perfect! You are AWESOME, John!!!!

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 08-14-2019, 04:43 AM
  2. Dual listboxes -- need to modify process
    By skydivetom in forum Queries
    Replies: 3
    Last Post: 08-11-2019, 04:19 AM
  3. Replies: 20
    Last Post: 08-03-2019, 03:21 AM
  4. Query modification
    By endri81 in forum Queries
    Replies: 28
    Last Post: 02-29-2012, 09:50 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