T
Tim
I promised Klatuu an update from this thread:
http://www.microsoft.com/office/com...8ada&catlist=&dglist=&ptlist=&exp=&sloc=en-us
(Do a search for "Undocumented Filter" and you'll find it just as easily).
The problem was fixed in Access 2003. In 2k3, you can reference the subform
control's filter property without an error. In Access 2k, you will get an
error.
To replicate this, build a crosstab query and set it as the SourceObject for
a subform control. Apply a filter to the query, and test this line:
MsgBox Me.subformcontrol.Form.Filter
Access 2k will give you an error. Access 2k3 will give you the filter.
I'm still working with Microsoft to get them to find a way for this to be
done in 2k, so if that happens, I will post back.
http://www.microsoft.com/office/com...8ada&catlist=&dglist=&ptlist=&exp=&sloc=en-us
(Do a search for "Undocumented Filter" and you'll find it just as easily).
The problem was fixed in Access 2003. In 2k3, you can reference the subform
control's filter property without an error. In Access 2k, you will get an
error.
To replicate this, build a crosstab query and set it as the SourceObject for
a subform control. Apply a filter to the query, and test this line:
MsgBox Me.subformcontrol.Form.Filter
Access 2k will give you an error. Access 2k3 will give you the filter.
I'm still working with Microsoft to get them to find a way for this to be
done in 2k, so if that happens, I will post back.