Use a combo box to control another combo box

[gary_getter1]

Ii want to make a combo box(a) for users to select it but there are many data, so i want to create another combo box(b) to control which data can display on combo box(a). Can i do so?

 

[ansentry]

If for example you wanted the first combo to hold car Makes and the second one to hold Models, and when you selected BMW from the Makes combo the Model Combo would only show BMW Models.

If that is what you want to happen, then do a search on Cascading Combo Boxes.

If I have misunderstood your question, please post back.

 

[gary_getter1]

If for example you wanted the first combo to hold car Makes and the second one to hold Models, and when you selected BMW from the Makes combo the Model Combo would only show BMW Models.

If that is what you want to happen, then do a search on Cascading Combo Boxes.

If I have misunderstood your question, please post back.

Yes, that is what i want to do.

And I create a table which have two fields to store the Makes and Models, how can i do a search on Combo Boxes?

 

[ansentry]

have a look at the attache sample.

Have a look how they function, I'm sure that you will be able to adapt them to suit your project

 

[gary_getter1]

Thank You ansentry, it very useful for me

But, i have another question, when try to do a cascading combo box in a form(fs) it is all right, the problem is when i open form(fs) as a subform of form(c), it can't fullly function and it have a pop up to let me input the Marks again.

 

[ansentry]

Post a copy of your db (with only test data) and I will have a look at it for you.

 

[gary_getter1]

Here is my project.

And i find another problem is it can't used on multiple combo box.

Please help me!!

 

[ansentry]

I have had a quick look at your db and if I understand it correctly the
Constituent table if for the parents and the infostudent is for the student (son or daughter)

What are you trying to make the infostudent table do?

 

[gary_getter1]

In my DB, Constituent table is for the student's personal info, and the infostudent is for the student's study record, each student have 1-3 playgroup, each playgroup have 2 combo box.

What i want to do is, the first one is used to select the region of the playgroup then the second one will only display the related playgroup.

Thank
------------------------------------------------------------------
gary

 

[Robert88]

Here is another reference, hope it helps.

http://www.fontstuff.com/access/acctut10.htm

Robert88

 

[gary_getter1]

Thank Robert88

The Websites is very useful, and i already fixed my problem.

Thank again.