Prevent report from running if a field is null

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

Access 2000. I would like to prevent a report from running if an individual
field in the report is blank/Null. The fields name is: [DateIssued] I'm
sure there is an easy way to do this. Any help please.
 
Randy said:
Access 2000. I would like to prevent a report from running if an individual
field in the report is blank/Null. The fields name is: [DateIssued] I'm
sure there is an easy way to do this.
Click to expand...


Normally, that is done by using a criteria in the report's
record source query. Then the report can be canceled if
there is no data for the report to process.
 
Another method is to check to see if that value is NULL before opening the
report. The down side of this is if the query is complicated, you could
actually have to run it twice (once to test for null, the other to open the
report).

Occassionally, I'll disablet the report preview button until certain
criteria are met. This might be one of those cases. To do that, I create a
subroutine on my form which I evaluate in the AfterUpdate event of those
controls that affect whether the button is enabled.

HTH
Dale
 
Back
Top