Query to select part or all of a table

[CoffeeGuru]

I need to give the user the ability to select either all of a table say
[tblStores].StoreNo

or only those stores where [tblStores].StoreNo Is Null

I cant for the life of me get my query to accept Null or Is Not Null in the parameter box.
What do I need to do.
Rethinking the problem is not an issue but I dont really want to go down the route of two queries.

The end game is to produce a subform to allow users to maintain tblStores

eg

tblStore
StoreNo | StoreNm
000001 | StoreA
<Empty>| StoreB
000003 | StoreC

Null returns
Store B

Is Not Null returns
StoreA
StoreB
StoreC

 

[CJ_London]

you should be allowing users access to queries, they should always go through a form.

Whithout knwing you query structure it is difficult to advise.

This is a current post on the same subject which may help

http://www.access-programmers.co.uk/forums/showthread.php?t=257560

 

[CoffeeGuru]

Hi CJ London

I understand your point and I am using a subform connected to an update query

I have continued to search the forums but none appear to help me, I'm using a check box.

I have made a very small simple example for anyone to look at.

1 table with 3 records 2 fields
1 query
1 subform