Printing Report from Form

[bborel]

I have a form I've created and need to be able to print a report from it based upon the current data. I've tried eveything and I'm stumped. The control I'd like to have the focus on for the report is a auto number field called WORK_ORDER. I'm having to use Access 95 for this.

Perfect scenario is the data is input and the WORK_ORDER field is an auto number that is not enabled. Once the data is input I'd like to click PRINT button and only current record prints our using report instead of form.

 

[sdk]

Hi,

First, has the record on the form been saved? (docmd.save will do that), otherwise the record won't exist yet and the report won't be able to run properly.

Then it should be as simple as:
DoCmd.OpenReport "YourReportName", acViewNormal, "[YourReportControlName] = " & Forms!yourForm!WORK_ORDER

hope this helps

Steve

 

[bborel]

Thanks, I didn't think about that. I'll try that and hopefully it will work, thanks.