get current sort settings

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.
 
G

Graham Mandeno

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)
 

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

Top