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?
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?