Help!

I have a combo box that is populated by a function. The function, gets all equipment numbers.

There is a second combo box that is populated with a list of Equipment components as applicable to the piece of equipment selected in the first combo box. This combo box is also populated by a function.

This information is needed to be posted to a form and as such the functions are called between the form tags.

Here is my delima. I don't know how to get the data from the first combo box to the second. With in the form tags, I call the populate combo 1 function. Based on the value that is visibly populated in to the combo box, I need the corresponding values in the 2nd combo box to be populated as well.

All of this also needs to happen in a requery situation. So that if I change the equipment number, the components for that equipment number also change.

HELP HELP HELP!