Tabbed reports?

[kdirvin]

Hi all,

I am using Access 2007 and I am trying to create a tabbed report. I tried doing this by adding a Tab Control in the Design section and then inserting a report on each of the tabs. Both of the reports are based on parameter queries, and when I try to open the form in Form View, Access will not stop prompting me for the parameters specified in my queries.

I do not know if it is my design that is flawed, or if the concept of tabbed reports is even possible in Access.

Thank you for any assistance in the right direction!

 

[boblarson]

So let me get this straight. You are trying to put reports on a page of a tab control (or several) on a FORM. Is that correct?

First up - regardless of whether that is true or not, I would change your queries to use a FORM for input parameters instead of parameter prompts as it will provide the value as many times as necessary with the user entering it once. Here is another set of reasons why:
http://www.tek-tips.com/faqs.cfm?fid=6763

 

[kdirvin]

Hi Mr. Larson,

Thanks for your quick reply. I am putting two reports on two pages of a tab control in a report, not a form. I mistyped that - my apologies.

Also - thanks for the tip on querying by form. In an earlier version of the report that I am creating, I used a report/subreport structure. Both the main and subreport were based on queries that prompted the user for a particular year, and having to enter the year twice *really* annoyed me. I am guessing that I can combine both parameters on one form, have the user enter it once, and save time?

Thanks!

 

[boblarson]

Tab controls are not for use on reports EXCEPT if you need to show different things for different groups. For example, where I work we have different statuses that a property can be in - Construction, Lease Up, Stabilization, etc. So, each of those has unique fields that need to show when that group is there. So we have a subreport for each group on a tab control with no tabs and then in the On Format event of the section, we have it show the applicable page of the tab control.