I am using the DoCmd.OpenReport Method in Access to automatically Print a report of a Receipt.
This is what I have chosen for the On Activate but it is obviously wrong....
'If the customer pays in full lets make the paid in full stamp appear.
If Me!txtCashTendered.value >= Me!txtTotalDue.value Then
Me!imagePaidInFull.Visible = True
Me!ImageBalanceDue.Visible = False
Me!txtBalanceDue.Visible = False
Me!imagePaidInFull.Visible = False
Me!ImageBalanceDue.Visible = True
Me!txtBalanceDue.Visible = True
Basically if the customer pays in full a "Paid in Full Stamp Appears" Else a "Balance Due Stamp Appears"
But (What I think is the problem) The report is not getting activated by being sent to the printer automatically....
So which event is the best for this option? I have tried several... On Current, On Activate, On Load, On Open, On Page
Thanks for the help.