Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sorting subform records (a2k)

    I have a subform based on a junction table and I would like to sort the records displaying in the subform alphabetically. The field I'd like to sort on is not the foreign key listed in the junction table but one of the fields in the linked table. What are my options for sorting?

    E

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: sorting subform records (a2k)

    (1) Create a query based on the junction table, or if necessary on the junction table and the linked table (not sure what that is), and specify the desired sort order in the query design grid.
    (2) Set the record source of the subform to the name of the query instead of the name of the junction table.

Posting Permissions

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