Hi All
I'm sure this has been asked before so apologies but I can't seem to find the answer I'm needing.
I have a continuous form FrmJobsAllocation based on a query QryJoballocation. The user selects a person to allocate each job to then clicks cmdSubmit which changes the status of all the allocated jobs to "Allocated".
Just now the user prints each job card (RptJobCard) individually which is time consuming. What I want to do is print all Job Cards that have a status "Allocated" automatically.
The logic is something like
For Each Job Where Status = "Allocated"
Print RptJobCard
Next
The report RptJobCard is based on a query which uses the JobNo as the criteria.
I'm sure it is simple but can't figure out how to pass each JobNo to the report as a criteria. Any help would be much appreciated
Thanks
I'm sure this has been asked before so apologies but I can't seem to find the answer I'm needing.
I have a continuous form FrmJobsAllocation based on a query QryJoballocation. The user selects a person to allocate each job to then clicks cmdSubmit which changes the status of all the allocated jobs to "Allocated".
Just now the user prints each job card (RptJobCard) individually which is time consuming. What I want to do is print all Job Cards that have a status "Allocated" automatically.
The logic is something like
For Each Job Where Status = "Allocated"
Print RptJobCard
Next
The report RptJobCard is based on a query which uses the JobNo as the criteria.
I'm sure it is simple but can't figure out how to pass each JobNo to the report as a criteria. Any help would be much appreciated
Thanks
