Parameters

[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

 

[Duane Hookom]

You can use something like:
Nz([Enter Teacher Name],[TeacherNameField])

 

[L Schwaegerl]

Forms![QBF_Form]![WhatCustomer] Or Forms![QBF_Form]![WhatCustomer] Is Null

This article explains exactly how to do it in detail.
http://support.microsoft.com/default.aspx?scid=kb;en-us;209645&Product=acc2000