I'm attempting to use the DlookUp function in the expression builder but it is not recognized as a built in function. Is there something missing in the setup of access to gain access to the function?
I'm attempting to use the DlookUp function in the expression builder but it is not recognized as a built in function. Is there something missing in the setup of access to gain access to the function?
maybe you type it wrong
DLookUp(«expression»; «domain»; «criteria»)
reinstall if failed.
I answered my own question. The dlookup function is only available in the expression builder if you're using a non web enabled access database. It a web form it is not accessible except through a VB Module