User Profile

Collapse

Profile Sidebar

Collapse
sealstone
sealstone
Last Activity: Dec 10 '12, 11:00 PM
Joined: Dec 10 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • sealstone
    replied to Combo Boxes Not Allowing Dynamic Sort
    in Access
    I have a main form of owning churches for consignment music. In my subform I list the music titles they own. I have a "Music ID" column in this subform which is a pointer to a table of unique music titles. This is the record source it is based on (a saved query):

    Code:
    SELECT DISTINCT Music.[Music ID], 
   Music.Title, 
   [Composer/Arranger] & "--" & [publisher] 
      AS [Comp/Arr/Pub],
    ...
    See more | Go to post
    Last edited by zmbd; Dec 11 '12, 12:02 AM. Reason: [Z:{Please use the <CODE/> button to format posted code/html/sql}{Stepped Posted SQL}]

      Leave a comment:

    • sealstone
      started a topic Combo Boxes Not Allowing Dynamic Sort
      in Access

      Combo Boxes Not Allowing Dynamic Sort

      I have a combo box on a form that is based on an ID but I am displaying a title. I want to sort by that title and another date field. I am doing that in the form's record source. However, the client is also requesting that they be able to sort "on the fly" by different columns in this form (which is a subform in datasheet view). Error messages happen when one tries to dynamically sort, and occasionally the form goes to read only. Any w...
      See more | Go to post
      No activity results to display
      Show More
      Working...