QBF - Checkbox

[radink]

Hello everyone. new here.



I've been trying to create a query by form. Doing simple things like finding text across different fields is no problem. What I also need to do, is check against check boxes. I can't seem to get the right criteria in the query to pull up only checked items. Everything I've found on the subject so far has been very cryptic and not helpful.

Any help would be greatly appreciated.
Thanks!

[orange]

Please show us your query.

[radink]

Well for first and last name I have this (in the criteria):

Like "*" & Forms!frmSearch.Fname & "*" Or Forms!frmSearch.Fname Is Null

(Then similar for last name)

I was trying the above for the checkbox but using =-1 but no luck.

Not sure what else I should put in there.

[orange]

Can you show us the sql for your query?
Do you get an error message?

[radink]

Can you show us the sql for your query?
Do you get an error message?

SELECT tblEmployee.FirstName, tblEmployee.LastName, tblEmployee.Ext, tblEmployee.Photo
FROM tblEmployee
WHERE (((tblEmployee.FirstName) Like "*" & [Forms]![frmSearch].[Fname] & "*") AND ((tblEmployee.LastName) Like "*" & [Forms]![frmSearch].[Lname] & "*") AND ([Forms]![frmSearch].[Photobox]=-1)) OR (((tblEmployee.FirstName) Like "*" & [Forms]![frmSearch].[Fname] & "*") AND ((tblEmployee.LastName) Like "*" & [Forms]![frmSearch].[Lname] & "*"));

No errors. Just doesn't do anything.

Thanks

[orange]

The check box your testing is a field in your table right?

Have you tried a query along these lines --- just to get the check box thing working

Select * from table where checkboxField = True (untested just trying to get that part working)

[radink]

tblEmployee.Photo is the checkbox field.

[orange]

If you run a test query

SELECT * from tblEmployee
where
tblEmployee.Photo =True

Do you get the proper records selected?

[radink]

That works.

[orange]

Was that the issue or is there more?
When you do your search, can you work with a basic query then add the ore complex elements once you get the basic stuff working?

[radink]

I think so, this has helped me alot. Thanks orange!

[orange]

You are welcome, glad to help.

[radink]

Well, this works great, but how do I implement this into the form im using to activate the search? I need the user to be able to check things off and have the query pick just those.

[orange]

You need to know the field names involved. You'll have to set up a query that is based on the controls on the form.

Your original post had the kind of things required.

Can you describe the search you're going to do in plain English, then work on the VBA?

There is a simple search video tutorial here.
http://www.datapigtechnologies.com/f...earchform.html

[radink]

Sure thing.

We have a database that we use to track jobs and clients.
In the data, we have text fields and check boxes.

So I want to make a form to drive a search that lets you enter text under for example, under the client name. Then we have check boxes that specify if they are government or schools, etc... So id like to have those on the search form also, so you could pick school and it would pick all of the schools, or maybe both, schools and government. I have the text boxes no problem. It's the check boxes that are giving me the headache.

I watched the video and Im good on that part.
Thanks.