Undocumented Filter?

T

Tim

Crosstab queries (among other sorts of queries), do not have a Filter property.

But create a form with a subform control, and put in the SourceObject
Property of the sf-control "Query.MyCTQuery" and you can do a filter-by-form
or a filter-on-selection.

But, when you have done that, test the various places you might find the
query's filter:

Me.Filter
....will be empty

Me.SubformControl.Form.Filter
....will give you an error

Me.SubFormControl.Form.Recordset.Filter
....will be empty

set qd = currentdb.querydefs("MyCTQuery")
qd.Properties("Filter")
....will give you an error that the property does not exist


Is there someplace else where this Filter is being stored, someplace that we
can get at it?
 
Top