Filter from Form cbo to Subform cbo

[WoodyAccess]

I have a main Orders Form and a subform for OrderDetails.

When I select the supplier in the main form I want only the products from
that supplier to be listed in the cbo on the subform.

Is this a filter in the after update of the main form cbo? How would I do
this?

 

[Matt]

Use the Link Child and Link Master Fields properties of the subform to link
the PK (combobox) to the FK in the subform.

 

[WoodyAccess]

But the combo box in the main form is not a PK. The main form is Orders and
so the PK is Order Number. The cbo in the main form is then just a list of
all the suppliers, so a supplier for that order can be chosen. Then after
that is chosen I want to go to the subform (OrderDetials) and chose from a
product cbo that has only got the products from the supplier chosen in the
main form cbo?

 

[Matt]

Ah – I See.

Check out this link:
http://www.mvps.org/access/forms/frm0028.htm

Since the 2nd Combobox is in your Subform, the syntax would have to be:
Me!YourSubformContomName.Form!cbxCombo2.RowSourceType = "Table/Query"
Me!YourSubformContomName.Form!cbxCombo2.RowSource = strSQL