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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reorder query 1
Query on a subform 1
Multi-field query calculations 8
Display Query Results on top of a Form 1
Build a subform using a select query as input. 7
Query, Qty< Reorder level I want "Order Now" to show. syntax? 1
Extracting Specific Data for query 1
Adding a query result to a form in Access 2007 1

Back
Top