Why would this one give me all rows, not just the ones that match my form 
search input:


strSQL = "SELECT DISTINCT [Khitfilm].[FilmID], [Khitkategori].[Kategori], 
[khitfilm].[Tittel], [khitpris].[Pris]" & _
         " FROM (khitfilm INNER JOIN khitpris ON [khitfilm].[FilmID]
[khitpris].[FilmID]) INNER JOIN Khitkategori ON [khitfilm].[FilmID]
[Khitkategori].[FilmID]" & _
         " WHERE EXISTS" & _
         " ( SELECT [khitfilm].[FilmID], [khitfilm].[Tittel], 
[Khitkategori].[Kategori], [khitpris].[Pris], [khitskue].[Skuespiller]" & _
         " FROM ((khitfilm INNER JOIN khitpris ON [khitfilm].[FilmID]
[khitpris].[FilmID]) INNER JOIN (khitskue INNER JOIN khitfs ON [khitskue].
[SkueID]=[khitfs].[SkueID]) ON [khitfilm].[FilmID]=[khitfs].[FilmID]) 
INNER JOIN Khitkategori ON [khitfilm].[FilmID]=[Khitkategori].[FilmID]" & _
         " WHERE " & Request.QueryString("valgID") & " LIKE '%" & 
Request.QueryString("searchID") & "%' ORDER BY " & Request.QueryString
("valgID") & _
         ")"