Automatically change Combo box values based on the value selection of another combo box on the same form

[jamilmurad]

Assalam o alaikum respected members
hope u r fine. I am posting this because I am facing a technical issue in my database which I have designed for my school/college. Actually I have a form where I have a Combo box field named Class and another combo box field named Group. Both fields are linked to two different tables not linked with each other. I want to limit Group options based on Class value selection such that only Pre engineering and Pre Medical options to appear in Group when a user selects Fsc in Class combo box but unfortunately all the available options appear regardless of class value.
Plz help me in solving this issue. I am hopeful that I will get help as always.
Regards

 

[theDBguy]

Hi. Maybe you could look into "Cascading Comboboxes." There should be some sample available here.

 

[jamilmurad]

Hi. Maybe you could look into "Cascading Comboboxes." There should be some sample avail

Hi. Maybe you could look into "Cascading Comboboxes." There should be some sample available here.

thanks for your response theDBguy. As per my knowledge Cascading Combobox is used with linked table fields, since in my database Class and Group fields are not linked so want to limit options on the form.

 

[theDBguy]

thanks for your response theDBguy. As per my knowledge Cascading Combobox is used with linked table fields, since in my database Class and Group fields are not linked so want to limit options on the form.

You can use whatever "limit" you had in mind. Can you show us some sample data to give us a clue?

 

[Uncle Gizmo]

I answered a similar question a few years back with a YouTube video which you can watch on my website here (Video No 4) :-

Combo Box - Nifty Access

Combo Boxes Combo Boxes are the most fascinating and useful "Controls" you can have on your Form. They have Many uses. Combo Boxes can be manipulated in all sorts of ways without using VBA. Once you've mastered the combo-box, and once you have mastered Queries, the building of queries in the...

www.niftyaccess.com

Cascading Combobox:-