Send reports to an .rft doc

[Mark.Innes]

I have a bit of code set up that when running a report it creates a separate rft file for each area but if one area has no information if stops with a Run Time Error 2501.

How do I get it that if an area returns no information it then doesn't produce a rft doc and carries on?

 

[simongallop]

Presume that the code is changing the criteria in a query and then outputting the report? If so then test the query for records and if record count is 0 then loop else output.

HTH

 

[Mark.Innes]

Thanks for that.

The criteria on the qry is set to >0 and the report is running like a macro where it goes through and creates a doc for each person.

I have got it to stop creating the error by putting in an error skip but now can't get it to resume for the next peson on the list.

Any idea's?

 

[simongallop]

What code are you using?

 

[Mark.Innes]

It's okay thanks, sorted

I entered a error skip and then a resume to bypass this

Thanks for your help!