Criteria in Query fed by drop-down

[latex88]

This doesn’t sound too hard but I cannot find the answer. I have a form using a query as its source that has a criterion fed from a drop-down box, example [forms]![formAnother].[dropdown]. This works fine when I choose an option from the drop-down to filter some records. However, how do I get the form to show all the records in the form when I want to see all the records? Since the criterion of a field is [forms]![formAnother].[dropdown], how do I get it to return something that tells the query to show all the records?

 

[Mile-O]

[forms]![formAnother]![dropdown] OR [forms]![formAnother]![dropdown] Is Null

 

[latex88]

[forms]![formAnother]![dropdown] Is Null gives me no data at all.

 

[Mile-O]

The whole thing I gave was the criteria - not one or the other.

 

[latex88]

you're talking about using your statement in the criteria section of the query right? If so, when I do that, after I close the query, it automatically change it back to

[forms]![formAnother]![dropdown]

 

[Mile-O]

Does it add a new calculated field?

 

[latex88]

yes.

I'm not sure what that field does.

I want to be able to create a button to tell the form to show all the records. So what would I do in my subroutine?

 

[latex88]

yes.

I'm not sure what that field does.

I want to be able to create a button to tell the form to show all the records. So what would I do in my subroutine?