hello,
here is my situation. i have several places on a form (currently subforms) that a combo box drop down list finds a record on my subform. my problem is that i need to view a company name, as well as a contact associated with that company. (there are multiple contacts per company).
i can get it to work by just using the company name, but i can't get it to work by using both the contact and the company name. when the company is select it fills in the subform. i need to link this to my main form so that i can view where a shipment is comming from and going to as well as other information.
any help would be great. thanks.
-Kevin531
here is my situation. i have several places on a form (currently subforms) that a combo box drop down list finds a record on my subform. my problem is that i need to view a company name, as well as a contact associated with that company. (there are multiple contacts per company).
i can get it to work by just using the company name, but i can't get it to work by using both the contact and the company name. when the company is select it fills in the subform. i need to link this to my main form so that i can view where a shipment is comming from and going to as well as other information.
any help would be great. thanks.
-Kevin531