473,320 Members | 1,904 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How do you filter an Access Sub-Report

I have several sub-reports in an Access report. All of the sub-reports use the same Query. I want to create a Filter so when the main report is opened, each sub-report shows is respective, (but different), records. I created in the Sub-reports Filter property the following:

"[Range]='Reports![West-3]![Text15]'" And "[GraveDesc] = 'Reports![West-3]![Text16]'"

Text15 and Text16 are text boxes in the sub-report where their Data property is hardcoded. Text15's is: ="West" and Text16's is: "4" (4 is text; not numerical). The main report is not related to the sub-reports using Master and Child criteria. The stupid/easy way to do this is to create 12 Query's for the 12 sub-reports but I want to learn how to do it the right way and use one query with individual criteria in the sub-report. Right now, I get all records, not filtered ones. Help please!

Chuck
Apr 21 '11 #1
2 7778
Solved: Simpler than the above Filter that didn't work. What works is: [Range] = "West" and [GraveDesc] Like "4*"
Apr 21 '11 #2
TheSmileyCoder
2,322 Expert Mod 2GB
The normal way to limit sup reports is to use the properties of the control containing the sup report. Look for the properties "Link Child Fields", "Link Master Fields". If for example your main report is customers and your supreport contains their orders, and they are linked by the Primary key of the customer ID_Customer, you would write ID_Customer in both the "Link Child Fields" and the "Link Master Field" to show only that customers orders for each report.

Im sure you can find some examples of this in the Northwind sample database.
Apr 22 '11 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Lou | last post by:
I'm using the Response Filter Class in MS KB article 811162 (http://support.microsoft.com/default.aspx?scid=kb;EN-US;811162) to generate a static htm page from an asp.net template page being...
2
by: Alain. | last post by:
Good evenig to all, I use Access 2000 and i want to build a database for my photographs (jpeg files). All the 3 methods I saw make the base grow up. Is it a activeX control which could display...
1
by: Simon | last post by:
Hello All I am trying to build a couple of forms in Access 2000. Whilst I have one form which has all of the contact details in it also generates (using autonumber) a unique id for the customer....
2
by: DD | last post by:
I have a command button that applies a filter by customer name, i want a Cmd Button to remove the filter, Access does not supply one can anyone help. Regards DD
2
by: Pj | last post by:
hi, i am new to vb.net and i am stuck at a particular point in my project. i have two nested classes (because vb.net does NOT allow multiple inheritance) ...
1
by: bwakefield | last post by:
Hello, I am currently working on a Stock Control database and I am trying to set a filter on the form using a combo box. At present I am using a continuous form with the combo box being placed in...
3
by: zivon | last post by:
I have two forms: clients orders when they both open, when I change clients it automaticly filter the orders for that client. now I created a form which includes 2 sub forms inside it......
1
ammoos
by: ammoos | last post by:
Hi Friends I have an issue in the MS Access Sub Form The Sub form contains Student Name, Address and one selection field(it’s a check box. in the database table, it specified as “Yes/No” field....
4
matthardwick
by: matthardwick | last post by:
Hi Everyone, I have a problem with Access that I can't seem to solve: I have a sub form recordset changing acording to the value of a drop down box. ...
1
by: Aaron Melo | last post by:
I am working on database and I want to open form and its two subforms as read when the user clicks a button on another form. I opens the form as read only but not the subforms. Here is my code for...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.