Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

I get a parameter Dialog when printing a report that is a subform that is located on a form.

Posted on 2012-08-28
5
Medium Priority
?
240 Views
Last Modified: 2012-09-05
I have a form called frmInductionHistory and a subform on that form that is called fromInductionChecks but  when I go to print it out, I get a  parameter dialog box that shows: Forms!frmInductionChecks.Form!Serial.

The name of the report is called rptInductionpg2b.
helpappendsubformInductionCheckL.zip
0
Comment
Question by:gigifarrow
  • 3
  • 2
5 Comments
 
LVL 22

Accepted Solution

by:
Flyster earned 2000 total points
ID: 38342725
You're getting that because in you have Forms!frmInductionChecks.Form!Serial in the criteria section of the query used for that report.

Flyster
0
 

Author Comment

by:gigifarrow
ID: 38342852
Thats because that is the name of the subform that the information is coming from. What should it be?
0
 
LVL 22

Expert Comment

by:Flyster
ID: 38343623
I'm at work right now and don't have access to your db. I believe I brought that up in your other post,

Previous Question

When I get home I'll take a closer look at it.
0
 
LVL 22

Expert Comment

by:Flyster
ID: 38344172
I don't see a form called frmInductionHistory, just frmMainHistory. When you have frmMainHistory open and you select print report, you get the parameter query. That's because frmInductionChecks is not open.
0
 

Author Comment

by:gigifarrow
ID: 38344900
form induction checks is a subform that is located on page 2 of the form frmmain.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question