What has happened is the database I was given to clean up is a purchase order database where now they want me to make a modification and I have searched the boards for a couple days now. In the current ways, the vendor is selected in the combo box, and then the part number populates and is stored, i.e. synchronized combo boxes and this takes place in the subform. What I am now being asked to do is to limit the combo box in the subform to just one vendor.
On the main form(frmMAIN) is a combo box called cboVEN and has all the vendors. When the vendor is selected, they want the combo box for the part number in the subform (cboPN) to only populate based on the cboVEN on the main form.
A few people have told me to go check out this link, yet I am having an issue trying to understand what to do.
http://www.mvps.org/access/forms/frm0031.htm
If anyone could suggest what I should do, I appreciate any help.
If it's easier, is there a way to filter the cboVENDOR in the subform to "mirror" the cboVEN on the main form?
On the main form(frmMAIN) is a combo box called cboVEN and has all the vendors. When the vendor is selected, they want the combo box for the part number in the subform (cboPN) to only populate based on the cboVEN on the main form.
A few people have told me to go check out this link, yet I am having an issue trying to understand what to do.
http://www.mvps.org/access/forms/frm0031.htm
If anyone could suggest what I should do, I appreciate any help.
If it's easier, is there a way to filter the cboVENDOR in the subform to "mirror" the cboVEN on the main form?
