Dlookup criteria

[aceSoft]

hello there i have this code and its giving me error

Me.Computation = DLookup("EquiVal", "tbl_classication", [tbl_classication]![Classification] = Me!Proj_Class And Me.ProjCost & " BETWEEN   [tbl_classication]![From]  and  [tbl_classication]![To] ")

Got problem with my criteria part, I want something like
-look on the table where classification like Proj_class


-and between my cost range.
I know its just on my syntax, hope someone guide me.

[pbaldy]

See if this helps:

http://www.theaccessweb.com/general/gen0018.htm

[aceSoft]

Thank you,, I got it properly...

Me.Computation = DLookup("EquiVal", "tbl_classication", Me.ProjCost & " BETWEEN   [tbl_classication]![From]  and  [tbl_classication]![To]" _
             & " AND Classification = '" & Forms!frm_assess!Proj_Class & "'")

[pbaldy]

Happy to help.