Help with combo box

[Eightball3]

I have a continuous form with a combo box on it as one unbound field. If I click on the combo box I want to drop down a list of items that come from another table but use three fields from the current record on the continuous form as the search criteria. The problem I'm having is that the data in the combo box does not change when I click on another record's combo box. The data from the previous record is displayed in the combo box. Can anyone help me with this? Thanks.

 

[Eightball3]

Nevermind everyone, I figured it out. Thanks anyway.

 

[nateveli]

Can you tell me how you did it, I have the same problem when putting more than one combo box on a form. Thanks!