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].
tblBUY is a temp table with parts that are currently on open reqs.
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
This information is also coming from the table [tblBUY].
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].
tblBUY is a temp table with parts that are currently on open reqs.
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
This information is also coming from the table [tblBUY].
What is the best way to accomplish this?
Thank you very much for your help with this!!!