G
Guest
Hello,
I have a Purchasing database that has a form containing a subform for each
purchase order. The form has a combo box, CBX1 lets say, containing suppliers
based on a table (tblSUPPLIERS) . The subform has another combo box, CBX2,
containing products that is based on a separate table (tblPRODUCTS) and
limited by the supplier entered in CBX1 using SQL. I have requery VBA codes
in the After Update field of CBX1 as well as in the On Current for the
subform.
Problem: for some reason, the products listed in CBX2 only contain the
products that have previsouly been ordered. For example, when I type a new
product into tblPRODUCTS (using a separate form) it is not listed in CBX2
unless I go directly into the Purchase Order table and add it there.
Any suggestions? Any help would be greatly appreciated!
I have a Purchasing database that has a form containing a subform for each
purchase order. The form has a combo box, CBX1 lets say, containing suppliers
based on a table (tblSUPPLIERS) . The subform has another combo box, CBX2,
containing products that is based on a separate table (tblPRODUCTS) and
limited by the supplier entered in CBX1 using SQL. I have requery VBA codes
in the After Update field of CBX1 as well as in the On Current for the
subform.
Problem: for some reason, the products listed in CBX2 only contain the
products that have previsouly been ordered. For example, when I type a new
product into tblPRODUCTS (using a separate form) it is not listed in CBX2
unless I go directly into the Purchase Order table and add it there.
Any suggestions? Any help would be greatly appreciated!