VBA code: Select combobox value filter orders subform.

[jakobt]

I have a form with a formheader. In the formheader I added a combobox to select a customer.

In the FORM I have a subform called orders.

Now I want to filter the subform based on the customerid selected in the combobox above.

Is it possible to add a macro in afterupdate in the combobox. So the orders table is automatically filtered on the customer id selected in the combobox.

 

[welshgasman]

You can just use the combo as the master link field.?
This is another way

Main Form ComboBox to Filter Records in SubForm

I have a problem filtering records in my subform using a ComboBox in the Main Form. I have tried options proferred in other forums and have still not git the desired result. I know I must be missing something as this looks quite simple. I have attached a screenshot to help. What I need to for...

www.access-programmers.co.uk