Solved

MS Access: Subform Referencing Subform

Posted on 2012-12-25
3
480 Views
Last Modified: 2012-12-25
Hello,

I have an MS Access 2007 form with two subforms.

I would like the subform 2 results to be filtered based on the selection in subform 1. I've tried implementing a proposed solution with an unbound text box, but I couldn't get it to work.

Attached is a screenshot explaining what I would like to do, along with a sample database.

It would be great if you could help, then I can implement in my live database.

Cheers.
Access-subform-Question.gif
SBP-Databasev4-dummy.zip
0
Comment
Question by:dabug80
3 Comments
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
ID: 38719971
Seems you have wrong child field.
SBP-Databasev4-dummy.zip
0
 
LVL 25

Expert Comment

by:-MAS
ID: 38719990
0
 
LVL 1

Author Closing Comment

by:dabug80
ID: 38720769
Thanks for your help. Wrong child reference in subform 2.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

776 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