Access Report Count

[schwarem]

I have a report that has some code behind it. When there are no records the code throws errors. Is there a way to determine whether a report with a filtered dataset has any records in it, so I can put this block of code in an if statement?

 

[KenReay]

Hi

There is an On No Data event, would that help?



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[dhookom]

Your code can use the [HasData] property of the report:
If Me.HasData Then
'code to run
End If

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]