educate889
Technical User
Any help would be greatly appreciated . . .
I have a Mainform (01_Main_Prod_Complaint) that is unbound with a combo (cboCustomerID) (2 columns... Company_ID and Company_Name bound to Company_ID) that uses a query for it's recordsource . . .
What I need is for the user to select the company that calls in a complaint in the combo box . . . then the subform (01_CC_sub) would list all "active" complaints and allow Cust Serv. Rep to imput a new record. I think I have part of it b/c I am using a query as the recordsource to the subform with the criteria of Company_ID = [Forms]![01_Main_Prod_Complaint]![CboCompanyID]. It seems to open correctly when the main form first opens . . . but then when you change the selection in combobox, the subform doesn't get updated . . . I have read alot about requery and the such, but can't get them to work for my usage.
I also have another combobox in the subform that lists the "Job_ID"s that are associated with the selected company in the Main form combobox!!
The last thing is that I need to capture the Company_ID selected in the combobox from the main form in the subform and bind it to the correct table where all the complaint info is being put.
Can someone point me in the right direction . . .
I have a Mainform (01_Main_Prod_Complaint) that is unbound with a combo (cboCustomerID) (2 columns... Company_ID and Company_Name bound to Company_ID) that uses a query for it's recordsource . . .
What I need is for the user to select the company that calls in a complaint in the combo box . . . then the subform (01_CC_sub) would list all "active" complaints and allow Cust Serv. Rep to imput a new record. I think I have part of it b/c I am using a query as the recordsource to the subform with the criteria of Company_ID = [Forms]![01_Main_Prod_Complaint]![CboCompanyID]. It seems to open correctly when the main form first opens . . . but then when you change the selection in combobox, the subform doesn't get updated . . . I have read alot about requery and the such, but can't get them to work for my usage.
I also have another combobox in the subform that lists the "Job_ID"s that are associated with the selected company in the Main form combobox!!
The last thing is that I need to capture the Company_ID selected in the combobox from the main form in the subform and bind it to the correct table where all the complaint info is being put.
Can someone point me in the right direction . . .
