Hello,
I'm using a form to enter inventory data into a table. The fields that the form is inputting into my tblInventoryData are TagNumber, PartNumber, Qty, Dept. I also have an tblItemList that has field names of PartNumber, PartDescription, UnitCost. What I would like to do is have a box on the form that would display the PartDescription when the PartNumber entered into the form matches a PartNumber in the tblItemList. I don't want the the PartDescription added to the tblInventoryData, I just what a display to confirm that the correct part is added. Can this be done? Any help would be much appreciated.