AUTO POPULATE subform from combo box selection

  • Thread starter Thread starter kealaz
  • Start date Start date
K

kealaz

I have a purchase order form [frmPO_ISSUE] with a subform [frmORDER_DETAILS]

On my form [frmPO_ISSUE] I have a combo box [VENDORNAME] which is populated
with only Vendors that are in my table [tblBUY]. There may be one or
multiple VENDORNAMES in this combo box. For each Vendor, we may be
purchasing one or more parts from said Vendor.

When I select a Vendor to issue the purchase order to, I would like my
subform [frmORDER_DETAILS] to auto populate with those parts that are
selected to be purchased from that vendor. This may be more than one part.

The information contained in the subform [frmORDER_DETAILS] are...

PART_NO
NAME
MANUF
MANUF_PN
QTY_ORDER


What is the best way to accomplish this?


Thank you very much for your help with this!!!
 
I forgot to mention, the information for my subform is all coming from the
table [tblBUY] also.
 
Back
Top