AUTO POPULATE subform from combo box selection


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

Advertisements

K

kealaz

I forgot to mention, the information for my subform is all coming from the
table [tblBUY] also.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top