LenseOnLife
New member
- Local time
- Today, 07:03
- Joined
- Mar 19, 2019
- Messages
- 3
Hi,
First time posting here so hope I remember to include everything.
I've stripped back all the rubbish and now down to the bare essentials. Report header has 2 controls txtCustomerName and txtTransactions. While these will be populated through OpenArgs, I currently setting them in the Report_Load event.
Option Compare Database
Option Explicit
Private Sub Report_Load()
Me.txtCustomer = "MyCustomer"
Me.txtTransactions = "99"
End Sub
Testing the report using 'Print Preview' is fine - see '00 ReportHeader' attached
Running the report from the form
DoCmd.OpenReport ReportName:="rptMouldingUsed_Customer"
I get the Runtime error 2501 and it is driving me mental. Especially since this is not the original problem I was trying to sort out !!!!!
Any ideas anyone?
Cheers,
Oliver
First time posting here so hope I remember to include everything.
I've stripped back all the rubbish and now down to the bare essentials. Report header has 2 controls txtCustomerName and txtTransactions. While these will be populated through OpenArgs, I currently setting them in the Report_Load event.
Option Compare Database
Option Explicit
Private Sub Report_Load()
Me.txtCustomer = "MyCustomer"
Me.txtTransactions = "99"
End Sub
Testing the report using 'Print Preview' is fine - see '00 ReportHeader' attached
Running the report from the form
DoCmd.OpenReport ReportName:="rptMouldingUsed_Customer"
I get the Runtime error 2501 and it is driving me mental. Especially since this is not the original problem I was trying to sort out !!!!!
Any ideas anyone?
Cheers,
Oliver