get current sort settings

  • Thread starter Thread starter JString
  • Start date Start date
J

JString

Greetings.

In my main form I have several subforms under different tabs. Currently
they're all set up to share a global query so that if a user filters the
records in one subform, all the others will produce the same results
automatically. Unfortunately I never included a procedure to handle sort
options because I wanted each user to use the standard sort buttons on the
toolbar.

What I would like to be able to do is to find a way to get the current sort
settings in the active subform so that I can apply it to the rest.

Many thanks in advance.
 
Hi JString

Me.[SubformControlName].Form.OrderBy

....should return you the current sort order for a subform.

(Note that this will not include and "ORDER BY" clause in the RecordSource
query)
 
Back
Top