form not setting value for report

[Guest]

I have a database that stores testing information. I also have 3 different
reports that pull the results of their respective queries. I have run each
query and each return the appropriate results. For each report, I have
created forms that allow the user to specify specific criteria for the
report. For example, one report returns tests based on equipment, the other
on specific data range, etc.

My problem is this: The report that asks for date range works fine. However,
the equipment report and the other aren't working. The respective form asks
for the data range and then a combo box to select the type of equipment. When
you select OK, the report appears, the equipment and dates also appear (using
=forms![Equipment]![StartDate], etc); however, no records are showing up.

Any suggestions?
Thanks!

 

[Allen Browne]

There could be several things going on here.

One possibilty is that the Nulls are failing to meet the criteria. Details
in:
The Query Lost My Records! (Nulls)
at:
http://allenbrowne.com/casu-02.html

Another is that Access is failing to recognise the data types of the
parameters. Details in:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html