Hello
Could anyone help me with this issue please. I have been searching for 2 days for a solution that works for me but have yet to find one, and I have looked at cascading combo boxes too but I just can't seem to get it to work.
I have an unbound combo box (cboGoToCustomer) on my main form (Customer Details) which I use to select customer records from my table (Customers)
I have a subform (Cast List Subform) linked to a table (Cases) which show information on cases linked to the customer selected from the main form combo (cboGoToCustomer)
All this works fine
Now I have another subform (Calls Subform) which is linked to my table (Calls). What I want is a combo box on this subform which shows only the results from the Title field (Title is in the Cases table) where the Customer field in the Cases table and the ID field in Customer Details table match. And then I want the value selected in this new combo box (so the contents of the Title field) saved in the Case field in the Calls table.
So essentially I guess I want a combo box on my Calls subform to filter the available cases based on the Customer selected on the main form.
I hope that makes sense but happy to clarify if not. I am not great with VBA so code examples and where to put it would be great.
Thanks in advance.
Could anyone help me with this issue please. I have been searching for 2 days for a solution that works for me but have yet to find one, and I have looked at cascading combo boxes too but I just can't seem to get it to work.
I have an unbound combo box (cboGoToCustomer) on my main form (Customer Details) which I use to select customer records from my table (Customers)
I have a subform (Cast List Subform) linked to a table (Cases) which show information on cases linked to the customer selected from the main form combo (cboGoToCustomer)
All this works fine
Now I have another subform (Calls Subform) which is linked to my table (Calls). What I want is a combo box on this subform which shows only the results from the Title field (Title is in the Cases table) where the Customer field in the Cases table and the ID field in Customer Details table match. And then I want the value selected in this new combo box (so the contents of the Title field) saved in the Case field in the Calls table.
So essentially I guess I want a combo box on my Calls subform to filter the available cases based on the Customer selected on the main form.
I hope that makes sense but happy to clarify if not. I am not great with VBA so code examples and where to put it would be great.
Thanks in advance.