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!!!
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!!!