Check Box easy question

[kathi2005]

Have a query by form that works for an inventory search. I want to add a check box control that the user can check if they only want to see results with current inventory. Getting the check box on the form is easy enough. What do I do in the query to show Is Not Null when a check in the box???

[hertfordkc]

Have a query by form that works for an inventory search. I want to add a check box control that the user can check if they only want to see results with current inventory. Getting the check box on the form is easy enough. What do I do in the query to show Is Not Null when a check in the box???

I understand your question to mean that you don't want any records in which the inventory is either null or zero.
To do that, I would change the possible null fields to "fieldx:nz([fieldx],0)"
AND have the checkbox set a filter in the form fieldx >= 0 by using the onclick event.
You will probably have to requery.

[kathi2005]

That kind of works. I need even out of stock items to show up if the check mark is not checked

[hertfordkc]

That kind of works. I need even out of stock items to show up if the check mark is not checked

null items are not carried?
So take out the calculated field i.e. fieldx:nz(fieldx,0).
If the box is not checked, the filter is
>=0

If the box is checked,the filter is
>0
I believe that if there an field entry in the criteria, a null value will not be included.
If true, then records containing null values would not be reported in either case.

[kathi2005]

how do I link the form to the query (that control anyway)

[hertfordkc]

how do I link the form to the query (that control anyway)

with a form and displaying fields. That usually means that you are opening a form based on a query. My answers were based on your having a working query operating in conjunction with the form, i.e the form's recordsource. My focus was on adding a filter or filters that worked with the checkbox to modify the results of the underlying query.

If you were really saying that you had a form based on a table which was displaying desired information, then you should develop a query which is based on that table, then develop a form based on the query. While there are other possibilities, this sequence is easy to follow.

I don't have enough experience on working with forms based directly on tables to help you beyond believing that what I've already offered might work.

[kathi2005]

My form is based on the query, but after the fact it was decided to add the check box to display on item's with stock

[hertfordkc]

My form is based on the query, but after the fact it was decided to add the check box to display on item's with stock

You can use the Onclick event to set the filter to the desired value.

Look at this link to see two examples of using controls to filter.

https://www.accessforums.net/forms/c...lds-18541.html

Db2 mod.mdb
Db2x.mdb