Add a where condition to the SQL in the Row Source of the Combo Box on the Subform.

Thanks Kevin! It took me a while to get the syntax right and to put a requery event in the after update of the main form but it is working!  This space is incredible!  Thanks for sharing your knowledge sir!!

Ok, another issue with this one. I have a main form(customer profilef) and several sub forms that can be accessed by clicking the label associated with the subform.  The subform in question, callinformationform, has a combo box titled ContactsCombo that stores the contact associated with the call.  When I switch between the customer on the main form if I am on the call info tab on the previous customer, the combo box doesn't requery even though I have a requery event in the customercombo combo box on the main form(callinformationform.form!contactcombo.requery), if I click on one of the other tabs and then back to the call info tab the contactcombo on the call information form does requery. Why does it not requery when I switch the customer on the main form?  The sub forms are not tab controls but I used the structure that Rick uses because he hates tab controls.

Thanks once again for any and all assistance.

ContactsCombo should be ContactCombo, no s.

I get a runtime error 424 object required

I believe I figured it out!