problems with parametized query

[shank]

I'm trying to setup an easy query that evaluates the users input on 12
fields. The parametized query functions OK, but I'm not getting the desired
results. I tried a couple different queries with no luck. What do I need to
do to get appropriate results on any or all entered criteria? I'm sure the
null fields are messing me up here somewhere...
thanks

Query #1 - assume criteria on field [OnMasterList] = No
Results = no records
--------------------------------------
SELECT Publishers.Title, Publishers.Artist, Publishers.Gender,
Publishers.Genre, Publishers.VocalRange, Publishers.GroupLevel,
Publishers.BestPic, Publishers.PD, Publishers.OnSyberSound,
Publishers.OnMasterList, Publishers.PreApproved, Publishers.Publisher
FROM Publishers
WHERE (((Publishers.Title) Like "*" & [Forms]![frmSearch]![Title] & "*") AND
((Publishers.Artist) Like "*" & [Forms]![frmSearch]![Artist] & "*") AND
((Publishers.Gender) Like "*" & [Forms]![frmSearch]![Gender] & "*") AND
((Publishers.Genre) Like "*" & [Forms]![frmSearch]![Genre] & "*") AND
((Publishers.VocalRange) Like "*" & [Forms]![frmSearch]![VocalRange] & "*")
AND ((Publishers.GroupLevel) Like "*" & [Forms]![frmSearch]![GroupLevel] &
"*") AND ((Publishers.BestPic) Like "*" & [Forms]![frmSearch]![BestPic] &
"*") AND ((Publishers.PD) Like "*" & [Forms]![frmSearch]![PD] & "*") AND
((Publishers.OnSyberSound) Like "*" & [Forms]![frmSearch]![OnSyberSound] &
"*") AND ((Publishers.OnMasterList) Like "*" &
[Forms]![frmSearch]![OnMasterList] & "*") AND ((Publishers.PreApproved) Like
"*" & [Forms]![frmSearch]![PreApproved] & "*") AND ((Publishers.Publisher)
Like "*" & [Forms]![frmSearch]![Publisher] & "*"));


Query #2 - assume criteria on field [OnMasterList] = No
Results = all records
--------------------------------------
SELECT Publishers.Title, Publishers.Artist, Publishers.Gender,
Publishers.Genre, Publishers.VocalRange, Publishers.GroupLevel,
Publishers.BestPic, Publishers.PD, Publishers.OnSyberSound,
Publishers.OnMasterList, Publishers.PreApproved, Publishers.Publisher
FROM Publishers
WHERE (((Publishers.Title) Like "*" & [Forms]![frmSearch]![Title] & "*" Or
(Publishers.Title) Is Null) AND ((Publishers.Artist) Like "*" &
[Forms]![frmSearch]![Artist] & "*" Or (Publishers.Artist) Is Null) AND
((Publishers.Gender) Like "*" & [Forms]![frmSearch]![Gender] & "*" Or
(Publishers.Gender) Is Null) AND ((Publishers.Genre) Like "*" &
[Forms]![frmSearch]![Genre] & "*" Or (Publishers.Genre) Is Null) AND
((Publishers.VocalRange) Like "*" & [Forms]![frmSearch]![VocalRange] & "*"
Or (Publishers.VocalRange) Is Null) AND ((Publishers.GroupLevel) Like "*" &
[Forms]![frmSearch]![GroupLevel] & "*" Or (Publishers.GroupLevel) Is Null)
AND ((Publishers.BestPic) Like "*" & [Forms]![frmSearch]![BestPic] & "*" Or
(Publishers.BestPic) Is Null) AND ((Publishers.PD) Like "*" &
[Forms]![frmSearch]![PD] & "*" Or (Publishers.PD) Is Null) AND
((Publishers.OnSyberSound) Like "*" & [Forms]![frmSearch]![OnSyberSound] &
"*" Or (Publishers.OnSyberSound) Is Null) AND ((Publishers.OnMasterList)
Like "*" & [Forms]![frmSearch]![OnMasterList] & "*" Or
(Publishers.OnMasterList) Is Null) AND ((Publishers.PreApproved) Like "*" &
[Forms]![frmSearch]![PreApproved] & "*" Or (Publishers.PreApproved) Is Null)
AND ((Publishers.Publisher) Like "*" & [Forms]![frmSearch]![Publisher] & "*"
Or (Publishers.Publisher) Is Null));

 

[shank]

never mind...
Got tired of working around the Is Null fields.
Populated 'em and it works fine.