G
Guest
I am trying to query a database with the criteria of a Main form and subform.
It will not take the ((DB2MAST_IVDETKBT.IKB_PART_NUM)=[Forms]![F: Error
Entry Sub]![Part Ordered])); for some reason. It continually asks me to
enter the data like a pop up entry box. I need to get it to pull from its
form box. This is what I have.
SELECT DB2MAST_IVDETKBT.IKB_QTY_SHIPPED
FROM DB2MAST_IVDETKBT
WHERE (((DB2MAST_IVDETKBT.IKB_INVOICE_NUM)=[Forms]![F: Error Entry]![Invoice
Number]) AND ((DB2MAST_IVDETKBT.IKB_PART_NUM)=[Forms]![F: Error Entry
Sub]![Part Ordered]));
It will not take the ((DB2MAST_IVDETKBT.IKB_PART_NUM)=[Forms]![F: Error
Entry Sub]![Part Ordered])); for some reason. It continually asks me to
enter the data like a pop up entry box. I need to get it to pull from its
form box. This is what I have.
SELECT DB2MAST_IVDETKBT.IKB_QTY_SHIPPED
FROM DB2MAST_IVDETKBT
WHERE (((DB2MAST_IVDETKBT.IKB_INVOICE_NUM)=[Forms]![F: Error Entry]![Invoice
Number]) AND ((DB2MAST_IVDETKBT.IKB_PART_NUM)=[Forms]![F: Error Entry
Sub]![Part Ordered]));