I have a form called POtoLOTtbl, it has fields PO No, Lot No. I have a subform linked by Lot No called RECIEVING1 with a suform linked by Lot No called SampleChemistry. I want to reference (and only reference because I don't have a field in the table for) PO No from POtoLOTtbl TABLE based on the Lot No on the SampleChemistry SUBFORM. This
=DLookUp("[PO No]","POtoLOTtbl","[Lot No] =" & [Forms]![SampleChemistry]![Lot No])
DOESN'T WORK
Willie
=DLookUp("[PO No]","POtoLOTtbl","[Lot No] =" & [Forms]![SampleChemistry]![Lot No])
DOESN'T WORK
Willie