Below is the SQL of what I had before using the is null. This worked when I tested it on 3 criteria but then I extended it to all 6 criteria the search results would show nothing. Any and all help is appreciated.
SELECT [FM Data].Zone, [FM Data].Mixer, [FM Data].Line, [FM Data].Equipment, [FM Data].Type, [FM Data].Color, [FM Data].[Item#], [FM Data].Source, [FM Data].[FM Library#], [FM Data].[Part#], [FM Data].Attachments
FROM [FM Data]
WHERE ((([FM Data].Zone) Like "*" & [Forms]![SearchForm]![Zonetxt] & "*") AND (([FM Data].Mixer) Like "*" & [Forms]![SearchForm]![Mixertxt] & "*") AND (([FM Data].Line) Like "*" & [Forms]![SearchForm]![Linetxt] & "*") AND (([FM Data].Equipment) Like "*" & [Forms]![SearchForm]![Equiptxt] & "*") AND (([FM Data].Type) Like "*" & [Forms]![SearchForm]![Typetxt] & "*") AND (([FM Data].Color) Like "*" & [Forms]![SearchForm]![Colortxt] & "*"))
ORDER BY [FM Data].Zone, [FM Data].Mixer, [FM Data].Line, [FM Data].[Item#], [FM Data].[FM Library#], [FM Data].[Part#];