Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-16-2009, 11:02 AM   #1
azammalick
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

Hello,
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.

Thanks,
Azam

azammalick is offline   Reply With Quote
Old 12-16-2009, 12:27 PM   #2
Kryst51
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:

Quote:
[Forms]![YourMasterFormNameHere]![StudentClasscontrolNameHere.]
Note: this will only work if the form you are pulling the filter from is open...
__________________
~Krystal


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
ACCESS 2010
Kryst51 is offline   Reply With Quote
Reply

Tags
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 09:07 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


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