Lookup value

[sahand]

is there any macro like dlookup function?

[JoeM]

What do you mean?
What exactly are you trying to do?
You can use DLOOKUP in queries and VBA.

[sahand]

Just wondering is any macro available as Dlookup function?

[JoeM]

I am afraid that doesn't make much sense in the Access world. While "macros" and "VBA" mean mostly the same thing in Excel, they do not in Access. Access macros are pretty limited in what you can do. There is no Access macro command for DLOOKUP. However, you can use the DLOOKUP function in Access VBA code.

If you explain exactly what it is you are trying to do, we may be able to guide you down the right path.