rubbernilly
New member
- Local time
- Today, 02:30
- Joined
- Oct 21, 2005
- Messages
- 7
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?
