Report that asks for user input

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Hi All!

I have a payment book that fills automatically from a table. OK.
Sometimes, I want to print a payment book manually, including all the
details just to print out the payment book. I don't want to store the
data at all; just print it.

Any ideas how I do this?

Thanks

Jeff
 
Reports are generally bound to tables or queries. You can use Me.Print to
place values on a report. This is a bit complex since you need to have
values and set the CurrentX and CurrentY to position the print on the
report.
 
Duane said:
Reports are generally bound to tables or queries. You can use Me.Print to
place values on a report. This is a bit complex since you need to have
values and set the CurrentX and CurrentY to position the print on the
report.
Click to expand...
Thanks Duane

Then, is it possible to make a form that will send the info to a table
and when then send the information to a report. Then, when the report
has been printed, the register in the table will be deleted?
Would I put some code in the report that when it has finished printing
it will delete the table's register? What would that code be?

That way, there will be no useless registers left in a table.

Thanks for any advice

jeff
 
I would not write code in a report that in any way attempts to mess with the
records in the record source of the report.
Is there a reason why you want to delete the records after the report has
finished printing? Maybe you could run the report from code in a form and
then have code in the On Close event of the form to either delete the
records or drop the table.
 
Back
Top