SQL 2000 SERVER+ACCESS ADP DLOOKUP
In ACCESS itself this DLookup function in the form works just fine-=DLookUp("RT","CCYPERUSD","[CCY]=[COMBO15]"), however this same function when I am using it in SQL server as a backend database and run it in the same form, it says "#error." This table CCYPERUSD has exact data types. I do not know if there is a specific "twist" I have to do for Dlookup to work in ADP. Please help.