Please Help

[NewToo]

Hello I'm new at this.

I'm getting a error massage that stating that my mdb. path is invalid. i know that the path going to the right place. any ideas?


stDocName = IsNull(DLookuk("[psswrd]", "[usr_tbl]", "usrnme='" & stdocusr & "'&quot)

 

[danvlas]

Your expression results in 0 or -1

Example: IsNull("Whatever value&quot returns 0 because IsNull function is False
IsNull(FieldWhoseValueIsNull) returns -1 because IsNull function is true.

So your path is evaluated as 0 or -1 instead of "C:\Path\FileName"

Regards,
Dan