S
SF
Hi,
I have a form with the following controls:
a listbox to display Contract #
a listbox of report name
a button to export to PDF
For Each varItem In Me.cmbContractNumber.ItemsSelected
StgCriteria = "[Ck_ContractID]='" &
Me.cmbContractNumber.ItemData(varItem) & "'"
PDFFileName = Me.cmbContractNumber.ItemData(varItem) & ".pdf"
Debug.Print Me.listReports; StgCriteria
DoCmd.OutputTo acOutputReport, Me.listReports, acFormatPDF,
PDFFileName, -1
Next varItem
It seem that all records was outputed to PDF, how can I tell Access to
output only select Contract item in the list
SF
I have a form with the following controls:
a listbox to display Contract #
a listbox of report name
a button to export to PDF
For Each varItem In Me.cmbContractNumber.ItemsSelected
StgCriteria = "[Ck_ContractID]='" &
Me.cmbContractNumber.ItemData(varItem) & "'"
PDFFileName = Me.cmbContractNumber.ItemData(varItem) & ".pdf"
Debug.Print Me.listReports; StgCriteria
DoCmd.OutputTo acOutputReport, Me.listReports, acFormatPDF,
PDFFileName, -1
Next varItem
It seem that all records was outputed to PDF, how can I tell Access to
output only select Contract item in the list
SF