Combo-box Help please

[Jackblack1]

I have a combo box set up with two choses: open and closed. Also I have another combo box set up beside it with 7 choses: EOS, NIGO, GGA, EOM, GIFT, and Referral. I would like to be able to select the closed choice and the second combo to disappear. Moreover, when the open choice is selected I would like the the second box to appear with the 7 choices to be selected. Now I have to take there selections and place them into another table names Gratuities List. How can I do this, I have searched Mr. Excel and found some examples of past question but I am not to good at understanding the code and the procedure, Help will be very much appreciated!

Thanks
Jim

 

[Jackblack1]

I have tried to create a relationship to see if that worked but no luck, can anyone help