ACCESS 97: Detecting ORDERBY in a sub form

[stevebmartin]

I have a form which contains a subform in Datasheet view.

The sortorder of the subform can be changed (by design) by using the standard Access datasheet menu's (right click at top of column)

My problem is that i need to detect this sortorder when spawning a report from the form using the data...

I hope i make sense...

keep em peeled...

[Ephesians]

Use the forms property OrderBy.. if null ignore it.. if not then add it to the form recordsource when spawning the report