You can send CDIPIU.frx and CDIPIU.frt files to me, then I will show how I would do it.
And to "make it easier to send off", you do not need ACCESS: I would use PDF writer/WIN2pdf or any similar product to direct printout to to the file_name.pdf format. Like:

set printer to NAME (PDF_printer_NAME_as _it_is_seen_in_Windows)
REPORT FORM CDIPIU NOCO TO file file_name.pdf

>Nothing wrong with #1 at all, just not sure how to build the expression from there. My Idea about Access was because I have to output the entire report to Access anyway to make it easier to send off to our different sites, right now it just prints out hardcopies.
>
>>1. I can not see that it is a problem. You need to modify the CDIPIU.frx report form, not the program/class that calls the report.
>>
>>2. If you need to export the finalinventory to access and run existing report from there, you could do it using Access Automation. The question is what is wrong with the simpliest way as in #1 above?
>>
>>>Only one problem, the print command is in the code of a class object of the program itself (don't blame me, I didn't write it). It looks somthing like this:
>>>
>>>IF This.Parent.chkPrint.Value = 1
>>> This.Parent.txtStatus.Value = "...Printing Report..."
>>> SELECT finalinventory
>>> INDEX ON IN_STOCK TAG IN_STOCK
>>> SET ORDER TO IN_STOCK
>>> REPORT FORM CDIPIU TO PRINTER
>>>ENDIF
>>>
>>>Question open to anyone: instead of further extensive mucking about with this code is there a quick and dirty way to alter this code to kick this programs output over to MS Access? I can do my output changes there real easy.