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.

I don't think you can use DLookup like this with a SQL back end. I don't think you WANT to use anything but views or stored procedures with SQL Server.

The reason is that SQL Server will optimize its views (queries). Ad hoc queries will not be optimized and usually pass too much data, thus also slowing down the network.

Anyway, I remember seeing that DLookup won't work with SQL. I think at Advisor.com.

HTH

mmcdonal