invalid use of null

[yolip]

Hi all,

i've got a error about the following statement in MS Access, the message was "invalid use of null".... i just don't understand what that means.. can any help?
PERID = DLookup("PERID", "tbApp", "APPLICATIONID=" & lngAppID)


regards

[kaihirst]

Hi,

the statemetn look sok, but it could have something to do with your database and a null reference in there.

ta

kai :wave:

[yolip]

the error will not occurs when there is a record in table "tbApp". But for the first time will always no record. can u teach me how to handle it?