Info in header in Print Preview but now when Printed

[2012accessnoob]

First let me say that I am really a novice at all of this. Most of what I know about Access I have learned by doing.

I currently have a few forms set up where the end user selects from a drop down box, that info is fed to the query and then into the report header. This was working fine in 2003 but we just upgraded to 2007 and now it is not.

Here is an example of what I currently have -
The end user chooses a status from the combo box then clicks the "run" button which has this code:

Private Sub cmdRunCorrespondencebyApprovalStatus_Click()
DoCmd.OpenReport "rptCorrespondencebyApprovalStatus-AllProjects", acViewPreview

Me.Undo

DoCmd.Close acForm, "frmChooseApprovalStatus-ReferenceforReport"
End Sub

In the query I am simply using this criteria:

[Forms]![frmChooseApprovalStatus-ReferenceforReport]![cboApprovalStatus]

In the Report I have a label:

=Forms![frmChooseApprovalStatus-ReferenceforReport]!cboApprovalStatus

When it opens in Print Preview it is fine. If you actually print it or change the view there is nothing there.



I know what is happening is the form is closing without that information being communicated to the final report, but I'm not sure how to fix it. Some of what I tried:

I moved the code to close the form to the close action of the report. Fixed the header issue but then me.undo didn't work and a new record was created every time a report was run.

I tried to unbound the form but wasn't having any luck being able to do that and still allow selection of the combo box items.

I put a me.undo into the "on close" of the form that didn't work.

Hopefully this makes sense and someone can point me in the direction of possibilities to fix this issue.

Thank you so much for your time.

[June7]

Don't understand why the Undo nor why a new record is created. Do you want to provide the project for analysis?

[2012accessnoob]

June7:

Thanks for your prompt response. I am attaching the database here in a zip. To point you in the right direction:
It opens to the main menu.
Click on "Reports - All Products"
Then click on "Correspondence by Approval Status"
Choose an approval status and then click "Run Report"
The report will open in print preview and the header looks hunky dory.
If you print it or change it to report view the header info disappears.

Thanks again for any assistance you can offer.

[June7]

I followed your instructions.

The report printed fine, header and all. I cannot replicate your issue.

Maybe your computer can't handle the font. Try some different fonts.

[2012accessnoob]

June7:

Thanks for checking. I just ran the report and I still have the problem. If I right click after it opens in print preview and change it to report view I lose the info in the header. I get "#name?" so it's obviously lost the connection. That's the same thing that happens when I print. It worked fine in Access 2003 and stopped working after our upgrade to 2007 so....

[June7]

Yes, I noticed the #Name after switching to Report view and an input prompt pops up. I notice frmChoose... is not open at this point so can no longer get data from the combobox.

The header does print but it has #Name. Oh, that is the issue. The form is closing too soon. Why 2003 worked and now 2007 doesn't, can't say.

Alternatives:

1. Close the form with code in report close event.

3. Pass the combobox value to report instead of report referencing form. Can use the OpenArgs argument of DoCmd.OpenReport. Set ControlSource of textbox on report to: =[OpenArgs].

[2012accessnoob]

Yes, the form is closing before it gets communicated to that final step. Thanks for the suggestions. I will take a look.