Print last transaction

  • Thread starter Thread starter Dave Mainland
  • Start date Start date
D

Dave Mainland

I use a customer form which has a transaction subform on
it to link the transaction to the customer. I query the
two underlying tables to print a receipt (report) for the
transaction. The receipt is printed by clicking a command
button on the customer form. This prompts the user to
enter the transaction number from the subform. Is there a
way to have the command button print a receipt of the last
transaction rather than having to enter the transaction
number as a parameter? Any help would be greatly
appreciated.
 
1. have the user select the transaction required in the subform (easiest to
sort on latest first in the subform)
2. set the command button to print the invoice for the current transaction
in the subform.form.
HTH
John
 
Back
Top