Input data into a subForm Query

[stapet]

I have a Main form with a unbound combo box that displays all distinct customers. When a customer is selected the subform displays all records for that Customer and allows for new data entry. Can I directly reference a field in the query to assign a value?



I'd like to automatically assign the "CustomerID" in the subform, based on the Customer selected in the Main Form.

Any help is appreciated!

[ranman256]

You'd put CustomerID field in both the main form and the sub form.
AND link the subForm CustID to the main CustID using the subForm properties:
link parent/master form,
Link child form.

enter CustID in both, THEN you can enter data direct into the subForm.

[stapet]

It doesn't let me link because the main form is not bound. There is just a Select statement behind the combo box? Is there a way to still link the forms?

[ranman256]

BIND the master form, then it works.