Hello.
What I have been tasked to do is create a purchase requisition database.
I have 2 forms:
Main form - frmMAIN
Subform (datasheet view) - frmDETAILS
The frmDETAILS shows part number, qty, cost, etc. My Issue is while the frmDETAILS is connected to frmMAIN with the frmMAINID, I have a combo box on the frmMAIN called cboVENDOR which I only want the part numbers of that selected vendor to show up on the subform in a combo box called cboPN.
I know how to create synchronized combo boxes on the same form, but does anyone have any suggestions on how to be able to limit the subform combo box to the combo box on the main form?
Thanks,
Flavi
What I have been tasked to do is create a purchase requisition database.
I have 2 forms:
Main form - frmMAIN
Subform (datasheet view) - frmDETAILS
The frmDETAILS shows part number, qty, cost, etc. My Issue is while the frmDETAILS is connected to frmMAIN with the frmMAINID, I have a combo box on the frmMAIN called cboVENDOR which I only want the part numbers of that selected vendor to show up on the subform in a combo box called cboPN.
I know how to create synchronized combo boxes on the same form, but does anyone have any suggestions on how to be able to limit the subform combo box to the combo box on the main form?
Thanks,
Flavi
