Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access 2010 Report as Source Object in Access Form

Posted on 2014-03-19
13
Medium Priority
?
687 Views
Last Modified: 2014-04-22
I have a form which contains a subform control. The SourceObject of the subform control is a report. The code in the Detail Format event of the report does not execute. Of course, if I run the report on its own, the code executes as planned. Is there a way to get code to execute in this scenario?
0
Comment
Question by:TechMommy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 3
  • 2
  • +1
13 Comments
 
LVL 48

Expert Comment

by:Dale Fye
ID: 39939962
Alison,

Although I cannot recall ever putting a report into a subform control, I'm guessing that when you do, Access uses the ReportView as opposed to the PrintPreview, and a lot of the events in the report don't fire properly in ReportView.

Have you tried manipulating the report behavior from within the main form?
0
 
LVL 66

Expert Comment

by:Jim Horn
ID: 39939963
>The SourceObject of the subform control is a report.
Even if this is possible, I highly recommend against it, as the properties of a report are different than a form.   For starters, reports are optimized to be printed on paper and with no user interface abilities, so none of the UI capabilities will work here.

Better to create a separate for to act as the subform.
0
 
LVL 11

Author Comment

by:TechMommy
ID: 39939978
I have never had a problem displaying a report in a form. It is a great way for a user to get a quick preview of how their data with be represented in the output. As an example you could have a preview of an invoice showing how the data entry will impact the printed invoice.

Also, manipulating the report behavior from within the main form doesn't work well.

Any additional thoughts or ideas?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 75
ID: 39940322
Sounds like ... this could be a limitation when using a Report in a Form ?
As a test - does code in *any* event in the Report execute ?

mx
0
 
LVL 11

Author Comment

by:TechMommy
ID: 39940329
The open event is the only code that runs. But, when you try to set the Visible property of a text box in the Detail section (for example), it doesn't exist, so the code doesn't execute (Object cannot be found).
0
 
LVL 75
ID: 39940413
Just curious also ... what if this was a subReport in another Report (even if just a blank report). Does the Detail Section code execute then ?

mx
0
 
LVL 11

Author Comment

by:TechMommy
ID: 39940453
Yes, the code executes fine if it is a subreport in another report.
0
 
LVL 75
ID: 39940468
Is this the first time you have tried this, or is it just not working in this instance ?
0
 
LVL 11

Author Comment

by:TechMommy
ID: 39948813
This is the first client that has needed code to execute in the subreport. I've used subreports in forms numerous times, but have just not encountered this specific situation before.
0
 
LVL 66

Expert Comment

by:Jim Horn
ID: 39949106
The only time I ever had to write VBA code in a subreport is to pull off the alternating greybars, before whatever Access version came out with the Alternate Back Color.

Any manipulation of columns (say last_name comma first_name) I was able to pull off in the query that fed your subreport.

So .. tell us what task dictates VBA code behind 'code to execute in the subreport'.
0
 
LVL 11

Author Comment

by:TechMommy
ID: 39949112
The user is requesting that they can view an invoice (report) from within a form. That way they can modify data in the form and preview how the printed invoice will appear. They want to hide and show different controls on the report based on the data in each detail line of the report.
0
 
LVL 11

Accepted Solution

by:
TechMommy earned 0 total points
ID: 40008260
I was never able to solve this problem. Unfortunately none of the comments helped me. I had to preview the subreport as a report. The users weren't happy, but the code executes as planned.
0
 
LVL 11

Author Closing Comment

by:TechMommy
ID: 40014347
Since I did not receive a viable solution, or any particularly helpful comments, I had to abandon what I was trying to accomplish.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
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…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

715 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