Function in Combo Box...

By teen_security ·
Hi, I was making a Tour Program on Excel. I have created two Combo boxes...
One is Titled "No. of Adults" and the second one is titled "No. of Children". And both of the combo boxes have same values in them...which are: 0,1,2,3,4
In the Tour program, you are not allowed to have more than 4 people. So what i'm trying to do is, i'm trying to put a function in my combo boxes so if i choose "1" in "No. of Adults", the values in the second Combo box will change to "0,1,2 & 3". Meaning because i chose "1" No. of Adult, i can have "0","1","2", or "3" No. of Children for the tour.
But i can't figure out how to do that, Please help. Thanks.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

You need the Microsoft Sample Form database

by sgt_shultz In reply to Function in Combo Box...

which has an example of filling in one field based on the value of another field.
you can download the Access sample form database and some others from
search terms : sample, form

Related Discussions

Related Forums