In my qeury, I want to show the record which the check box is checked. May I knwo what is the value I should put in the criteria? Is it -1?

Hi;

True

HTH.

But how come it cannot show me the result?

Emily,

If you mean that you have a record with a Yes/No checkbox field, and you have checked the checkbox. Yes? And then you have a query, where you have the criteria -1 in that field, which is correct. But the query does no return the selected record. Is that the situation?

Here's one possibility... Is the form still open, with the record you have checked the checkbox is still the current record? You may need to force the save of the record. If you check the checkbox, the query will not detect this until the record is saved. So either the form has to be clodes, or move to another record on the form, or use code to explicitly save the record.

Are there any other records that have a check box checked or is it the current record on the form in which you place the criterion for your query ?

Yaya..I have another field which is also a check box...

Hi Steve,
You are right...You understand my post clearly?

But how am I suppose to save it explicitly?

Is it using this statement?

If Me.Dirty Then Me.Dirty = False?

Yes, Emily, that will do it.

I put the line under check box on click event...but still cannot response...

Emily,

Not the Click event. You willl need it on the After Update event of the checkbox. And probably can be simplified... just put:
Me.Dirty = False

Hey Steve,

Thanks a lot for your help...

Have a nice day... (IMG:http://www.utteraccess.com/forum/style_emoticons/default/cool.gif)