Solved: Check if exists

[Marcster]

I have a string variable: strFilename
And a query: qryImportedFilenamesList which only returns one field, FileName
What I am trying to do is, if strFilename exists in qryImportedFilenamesList then msgbox "Already exists."
else
msgbox "Does not exist."

strFilename is a file name of a potential import file, I'm checking to see if it has already been imported.

Thanks,

[Marcster]

I done it.

If IsNull(DLookup("[Filename]", "qryImportedFilenamesList", "[Filename] = '" & strfile & "'")) Then
msgbox "Does not exist."
else
msgbox "Already exists."
End if