Go Back   Access World Forums > Microsoft Access Discussion > Forms

Thread Tools Rate Thread Display Modes
Old 12-16-2009, 11:02 AM   #1
Registered User
Join Date: Dec 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
azammalick is on a distinguished road
Post Filter Subform ComboBox based on Master Form ComboBox selection

I am using Access 2007, where I have a Master Detail Form. I want to filter the Subform Combobox Student Name list based on the Master Form Combo Box selection of Student Class. So how I complete this task, hope any one will help me to solve my issue.


azammalick is offline   Reply With Quote
Old 12-16-2009, 12:27 PM   #2
Singin' in the Hou. Rain
Kryst51's Avatar
Join Date: Jun 2009
Location: Texas
Posts: 1,898
Thanks: 0
Thanked 1 Time in 1 Post
Kryst51 will become famous soon enough Kryst51 will become famous soon enough
Re: Filter Subform ComboBox based on Master Form ComboBox selection

in the query for the combox box you want to filter on (Student Name combo box) in the criteria for the student class Add something like:

Note: this will only work if the form you are pulling the filter from is open...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
- Table defined lookups, not lookups in general
Kryst51 is offline   Reply With Quote

combo box sub form filter

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Form entry based on subform selection speakers_86 General 1 08-27-2008 11:31 AM
filter form when criteria in subform cardgunner Forms 9 03-24-2008 06:31 PM
Filter Main form from Subform Magibwan Forms 7 07-25-2007 03:02 AM
Problem with ComboBox selection to drive query criteria. mev Queries 4 06-08-2007 10:05 AM
Filter by Form and Nulls on subform? DataMiner Forms 0 01-12-2004 01:20 PM

All times are GMT -8. The time now is 04:59 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World