Filter expression passed with DoCmd

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

It appears that the filter expression passed to
a report as a part of the DoCmd expression
is not available in the Open code.

I.e., Me.Filter is null.

When? OnLoad?
 
Bill said:
It appears that the filter expression passed to
a report as a part of the DoCmd expression
is not available in the Open code.

I.e., Me.Filter is null.

When? OnLoad?
Click to expand...


Reports don't have a Load event. I find that the Filter property is
populated in the Format event of the Report Header section, but I can't say
what earlier event might make it available.

Note that in a form -- the subject of this particular newsgroup -- the
Filter property is populated in the Open event.
 
Back
Top