getting an error on dlookup...

[Bkenney228]

I wanted to see if someone could give me some direction. I am getting an error in my code when I open my form. the error occurs on a dlookup command. I downgraded the DB from XP to 97 for a fellow employee who does not have XP yet. The DB works great for me in XP, but for some reason it will not work in 97. We have the same DLL's loaded ( with the exception of the versions, Im using 10.0, hes running 8.0 ). I can open all the forms except for this particular one.
Any information or ideas would be greatly appreciated.

 

[glalsop]

Perhaps you post the DLookup expression? There are numerous functions available in Access XP that are not available in 97.

-Gary

 

[Bkenney228]

strUser = FindUserName()
FindUserID = DLookup("TechID", "TechTbl", " TechEmpID ='" & strUser & "'")
End Function

this is the point where I am getting the error. I have a feeling it has to do with the DLL that is associated wtih dlookup, but I cant be sure.

 

[PHV]

Have you tried to launch msaccess with the /decompile switch and then compile the project ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244