Filter from Form cbo to Subform cbo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Use the Link Child and Link Master Fields properties of the subform to link
the PK (combobox) to the FK in the subform.
 
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?
 
Back
Top