Dear all,

I have a report that contains invoices, each invoice has a unique number (invNo)

I want to export the invoices to snapshot reports, and have the filename equal the invoice Number, I have code to open a recordset, then scroll through the recordset, opening and indivudial report for each invoice. . .

This is where I get stuck, I call a outputto event, but how do I set the filename to be equal to a field in the recordset ?

Thanks in advance, I am sure this is an easy problem, but I have just spent 5 hours pulling out my hair, and now I am close to baldness !!!!

Regards

Doddy

:)

Sorted - The search feature is a god-send :) :) :)