Hi Guys,
Having an issue with one of my macros and can't seem to find a solution, wonder if anyone can help.
Basically I have a report called rptCustomerInvoice which is based on a query (qryCustomerInvoice) and to generate an invoice you enter the JobID using a parameter value in the query. (In the query for the criteria for JobID it's [Enter Job ID:]
But what I am also trying to achieve is to have a button on the Jobs form, which shows details of the jobs, that was also open this invoice based on the value of the JobID field on this form, the macro so far looks like this:
OpenReport
ReportName: rptCustomerInvoice
Where Condition: ???
This where condition is where I am trouble I have tried qryCustomerInvoice.JobID = frmJobs.JobID and the table, so basically my question is, what do I need the where condition to be to achieve what I want?
Any help is appreciated,
Ryan