Dlookup 2 criteria

[Directlinq]

How can i change this code so if a record in the table TblArtist has the artist string in the artist_name column and has artistid string in the artistid column of the same record it returns false?

If IsNull(DLookup("[artist_name]", "[TblArtist]", "[artist_name]=""" & artist & """")) = False Then

Many Thanks

 

[Scooterbug]

How can i change this code so if a record in the table TblArtist has the artist string in the artist_name column and has artistid string in the artistid column of the same record it returns false?

Many Thanks

DLookup only returns one value. So if you are looking to get a second value, you will need to do a second DLookup. I would do a dlookup of the Primary key of both dlookups and if they match, then you can return false.

If DLookup("[ArtistID]", "[TblArtist]",  _
"[artist_name]=""" & artist & """") =  _
Dlookup("[ArtistID]","TblArtist", _
"[ArtistID]=" & artistid Then