M
marjweir
When I use openargs with a "Where" condition in an OpenReport command
the "Where" criteria do not appear in the called reports Filter
Property. When I omit the openargs, it seems to work. I am confident
of the syntax of the "Where" condition statement, as it has worked in
other combinations of parameters.
Is there anything inherently incompatible between the "where" and the
"openargs" parameters? I am also opening the report with acdialog.
See example below.
dim strcriteria as string
dim stdocname as string
dim stfilteron as string
strcriteria = "[Active] = True" 'or false or ""
stdocname = "Case Managers List Short"
stfilteron = "0" ' or "-1" depending on the entries that control
this
'all these variables are being set correctly in this part of the
program
DoCmd.OpenReport stdocname, acViewPreview, ,strcriteria, acDialog,
stfilteron
'When I run the program and step through the process in the form_open
of the report, I see that the stfilteron value in openargs is set
accurately, but there is no content in Me.Filter.
I am trying to test the content of the Filter Property and insert
content into a descriptive label in the Page header section to display
the criteria more gracefully than just printing the Me.Filter in that
label. In any event the me.filter property does not seem to be
changing the way I would expect it to.
When is that property changed, if at all?
the "Where" criteria do not appear in the called reports Filter
Property. When I omit the openargs, it seems to work. I am confident
of the syntax of the "Where" condition statement, as it has worked in
other combinations of parameters.
Is there anything inherently incompatible between the "where" and the
"openargs" parameters? I am also opening the report with acdialog.
See example below.
dim strcriteria as string
dim stdocname as string
dim stfilteron as string
strcriteria = "[Active] = True" 'or false or ""
stdocname = "Case Managers List Short"
stfilteron = "0" ' or "-1" depending on the entries that control
this
'all these variables are being set correctly in this part of the
program
DoCmd.OpenReport stdocname, acViewPreview, ,strcriteria, acDialog,
stfilteron
'When I run the program and step through the process in the form_open
of the report, I see that the stfilteron value in openargs is set
accurately, but there is no content in Me.Filter.
I am trying to test the content of the Filter Property and insert
content into a descriptive label in the Page header section to display
the criteria more gracefully than just printing the Me.Filter in that
label. In any event the me.filter property does not seem to be
changing the way I would expect it to.
When is that property changed, if at all?