Request user info during report

[RandyBlackburn]

Hi,

Just before the end of the report, I'm trying to tell the user the account balance (as computed by the report), and ask him how much of a refund will be provided, and allow him to enter some comments. The refund amount and comments will then print on the report.

So I call a form in the report footer OnPrint event. This seems to be working pretty well if I preview the report (except the user has to go to the last page). However, if I open the report normally (to print), it doesn't stop, even if I make the form a modal popup.

Any suggestions on:
a)how to avaoid previewing the last page, and
b)how to get the report to pause before completing the print?

Thanks in advance,
Randy

 

[KenReay]

Hi

I think I would approch this from a slightly different angle.

Take the existing query which drives the report and change it into a make table query Thus 'freezing' the situation.

Run the above from a form, and display the total, and get the user commenst into form controls, have a button on the form which runs the report (now based on the 'made' table and the data from the form (using Forms!MyForm!Comments etc)

Hope this helps Regards

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

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

UK