Combobox...selected value not replicated to subform

[jakobt]

I have a form:
I inserted a combobox with a customer Id and client name
I inserted a subform with orders.
The childfield is customerid.orders the master field is costurmerid.costumer.


When I select a customer in the combobox...the orders for the customer is not automatically updated in the subform?

(The form record source is set to customer)

 

[jackd]

Well I wanted to see the fields in your tables in order to suggest the code. Since there are at least 2 ways to relate the main form records with matching subform records and I don't know your fields nor your current structure, I'll point you to 3 video tutorials that explain the 2 methods.

Method 1 --linkMaster and Child fields based on your tables
see

Method 2 --unbound combo on main form, vba code to filter subform records based on the mainform combo and
techniques to clear the subform control values on load and if no selection has been made in the mainform combo.
see

and

Good luck.

 

[Micron]

It's not clear to me if you want to filter the subform or make a field on it equal to a value that you select in the main form combo. Regardless, the subform reference syntax is Forms!FormNameHere!subFormControlNameHere.Form to refer to the form. After that goes the control name, form property or method that you want to use. So to make control txtMyTextbox = to "cat" for example, it would be
Forms!FormNameHere!subFormControlNameHere.Form.txtMyTextbox = "cat"

NOTE that subFormControlNameHere is the name of your subform control that contains your subform.