Parameter query as report's recordsource

  • Thread starter Thread starter Malee
  • Start date Start date
M

Malee

Is it possible to pass values programmatically to parameters in parameter
query which is the recordsource of report ? I have a form for user to fill
in these values and an command buttom to open this report. I don't want
system to show input dialog box for these parameters. Is that possible ?

TIA
Malee
 
Malee said:
Is it possible to pass values programmatically to parameters in parameter
query which is the recordsource of report ? I have a form for user to fill
in these values and an command buttom to open this report. I don't want
system to show input dialog box for these parameters. Is that possible ?
Click to expand...


No. You either have to change the report query's SQL or, if
all you need is criteria values, use the OpenReport method's
WhereCondition argument.
 
Malee

Not sure I understand. If I use a form to "collect" values, a query that
references that form (and those values), and a report that uses that query
as a source, the only way I get input dialog boxes for parameters is if I've
misspelled the references in the query.
 
Back
Top