Parameters

  • Thread starter Thread starter BJM
  • Start date Start date
B

BJM

Is there any way/syntax/code that you can have a query
return all records if a parameter dialog box is left blank
at runtime?

To explain:
In a query that is the recordsource for a report, I have
parameters on two feilds, one to specify which of a series
of teachers and the other to specify which of a series of
students the report will return a list of comment field
values for.

Is there any way that (without having two separate
reports,) if the value returned by a parameter is null (in
other words, if the field is left blank) the query will
return all records instead of cancelling as the default
action seems to be?

Thanks,
BJM
 
Back
Top