I have a Masterform, which handles all the information header of a ReceivingReport. You must select a PO Number from a combo box, and fill out the necessaries information as well. Everything works fine up to this point.
My subform on the other hand works if I keep it very basic but I want my second combo box located in my subform; which is base off the ID from the first combo box in the masterform to display only items from the PO Number ID.
I know my Query isn't working, since its not even displaying a record. But I can't seem to understand how to pull the information from the masterform combo box to use it correctly to retrieve the correct data.
As you can see in the query image, I was using this to retrieve the bound column PurchaseOrderID from the first combo box.
[Forms]![frm_addReceiveReportInformation].[Form]![cbo_PurchaseOrderID]
