Form queries. Multiple checkboxes.

[radink]

Hey all,

Im a little stuck here.

I have a form Im using to run a query. The form has multiple text fields and check boxes. Everything works fine If I just select (any)one of the check boxes. If I check more than one, I get no results. (which is because no records have them both selected). So if I change them or OR in the SQL code, I can get them to work, but then they stop working individually.

My criteria for the checkbox is:
IIf([forms]![frmsearch]![hist]=True,True,False)

Changing "hist" to each appropriate field.



The SQL is as follows:

SELECT [tblProject Info].[GALE JN], [tblProject Info].[Project Name], [tblProject Info].[Client Name], [tblProject Info].[Project Description], [tblProject Info].[Date Started], [tblProject Info].Type1, [tblProject Info].Type2, [tblProject Info].Type3, [tblProject Info].[Total Project Fee], [tblProject Info].Status, [tblProject Info].[Proj Mngr], [tblProject Info].Historical, [tblProject Info].Architects
FROM [tblProject Info]
WHERE ((([tblProject Info].[GALE JN]) Like "*" & [Forms]![frmSearch]![jobnum] & "*") AND (([tblProject Info].[Client Name]) Like "*" & [Forms]![frmSearch]![client] & "*") AND (([tblProject Info].Type1) Like "*" & [Forms]![frmSearch]![types] & "*") AND (([tblProject Info].Historical)=IIf([forms]![frmsearch]![hist]=True,True,0)) AND (([tblProject Info].Architects)=IIf([forms]![frmsearch]![arch]=True,True,0)))
ORDER BY [tblProject Info].[GALE JN];

It's like i need it to do AND and OR.

Thanks for any help.

[orange]

A couple of suggestions that you may find helpful.

. don't use spaces in your table and object names. Find a naming convention and use it. You can Google Hungarian Naming, Leszynski naming convention etc. There is one here http://www.databasedev.co.uk/naming_conv.html

.There is a video tutorial on a search form here. You may get some ideas from it.
http://www.datapigtechnologies.com/f...earchform.html

good luck

[radink]

Thanks again orange. The naming was done before I worked here. I always use a naming convention.

[orange]

Good for you. Yes, sometimes we "inherit" some gems.

Hope the Search tutorial is useful.

[radink]

That tutorial didn't have what i was looking for, but thanks.