You cancelled the previous operation error in dlookup function

[mhs5466]

Hi All,



Can some body correct the following code please, as I am stuck with it...

Me.RecomVendor = Nz(DLookup(Nz("RecommVendor", ""), "tblPettyCash", "[dn] = '" & Me!PCPNo & "'"), "")

Note : All of them are text fields...

I get " You cancelled the previous operation" error while i run it, please some body solve it for me, it will highly be appreciated.

Thanx

Sunny

[dcrake]

Your code is wrong:

Me.RecomVendor = Nz(DLookup(Nz("RecommVendor", ""), "tblPettyCash", "[dn] = '" & Me!PCPNo & "'"), "")

What you are saying if there is nothing in the field RecommVendor do not look in any field which would translate to

Me.RecomVendor = Nz(DLookup("", "tblPettyCash", "[dn] = '" & Me!PCPNo & "'"), "")

Should be

Me.RecomVendor = Nz(DLookup("RecommVendor", "tblPettyCash", "[dn] = '" & Me!PCPNo & "'"), "")

David

[mhs5466]

Thanx alot for replying David

Its ok now, I have already solved it...actually it was my mistake that i was trying to retrive a field which was not available in the table, instead of RecommVendorName i was putting recmmvendor in the function.

Any ways, I appreciate your help and support..

Sunny