Apr 19, 2011 #1 rwn Technical User Dec 14, 2002 420 US I had a DLookup in Access 2003 and it worked fine as below. =DLookUp("QTYPER_02","qry_ProductStructure","txtPRTNUM_01=PARPRT_02") but in Access 2007 is shows ERROR in the field. Any help is appreciattted. Thank you!
I had a DLookup in Access 2003 and it worked fine as below. =DLookUp("QTYPER_02","qry_ProductStructure","txtPRTNUM_01=PARPRT_02") but in Access 2007 is shows ERROR in the field. Any help is appreciattted. Thank you!
Apr 19, 2011 #2 lbass Technical User Feb 9, 2002 32,816 US This post is in the wrong forum. Please post to Microsoft Office forum. -LB Upvote 0 Downvote