Reordering Subform/Query

  • Thread starter Thread starter SheldonMopes
  • Start date Start date
S

SheldonMopes

I have a form containing a subform bound to a query. I would like to
have command buttons on the form to that would result in the query
result being reordered. For example, the query defaults to show the
data in date order, but I would like to click a button on the form to
cause it to display in order of LastName, etc. When I change the ORDER
BY on the form (and subforms0 properties, nothing happens. Any help
would be appreciated. Thank you.
 
I have a form containing a subform bound to a query. I would like to
have command buttons on the form to that would result in the query
result being reordered. For example, the query defaults to show the
data in date order, but I would like to click a button on the form to
cause it to display in order of LastName, etc. When I change the ORDER
BY on the form (and subforms0 properties, nothing happens. Any help
would be appreciated.
Click to expand...


Normally, that should work. Did you forget that you also
need to set OrderByOn = True?
 
Back
Top