Hi guys
I've been trying to figure this out but am struggling.
I have a form that displays a list of outstanding Workorders (these are basically invoices) in Continuous Forms mode. There is lots of information displayed including name, address and of course the unique Workorder number displayed. This form is called "fAll Valid Workorders Owing Money"
There is a command button that when clicked, uses VBA to do some stuff and then create a PDF version of the invoice that is then emailed out to the customer.....this has been working well.
I decided to create another form, called "fStartForm" and create 3 tabs.
I then attached the "fAll Valid Workorders Owing Money" form to the first tab (lets call it Page1).
Ok, here's the issue.
Everything works well EXCEPT the part where it creates the PDF file.
I think the issue is because the query within the PDF report attempts to find the "WorkorderID" from ""fAll Valid Workorders Owing Money" using the following but can't because of the fact that it is in a Tab control on the "fStartForm":
[forms]![fAll Valid Workorders Owing Money].[WorkorderID]
I have tried to change the above to correctly reference the [WorkorderID] but just can't seem to figure it out....I'm missing something.
I hope I have explained myself clearly.
Your help is very much appreciated.
Cheers
Greg
I've been trying to figure this out but am struggling.
I have a form that displays a list of outstanding Workorders (these are basically invoices) in Continuous Forms mode. There is lots of information displayed including name, address and of course the unique Workorder number displayed. This form is called "fAll Valid Workorders Owing Money"
There is a command button that when clicked, uses VBA to do some stuff and then create a PDF version of the invoice that is then emailed out to the customer.....this has been working well.
I decided to create another form, called "fStartForm" and create 3 tabs.
I then attached the "fAll Valid Workorders Owing Money" form to the first tab (lets call it Page1).
Ok, here's the issue.
Everything works well EXCEPT the part where it creates the PDF file.
I think the issue is because the query within the PDF report attempts to find the "WorkorderID" from ""fAll Valid Workorders Owing Money" using the following but can't because of the fact that it is in a Tab control on the "fStartForm":
[forms]![fAll Valid Workorders Owing Money].[WorkorderID]
I have tried to change the above to correctly reference the [WorkorderID] but just can't seem to figure it out....I'm missing something.
I hope I have explained myself clearly.
Your help is very much appreciated.
Cheers
Greg