Bypass a parameter to show all

[Angel69]

I've used this parameter back in Access 2.0 where I ask for I put [What location?] as the parameter and users can put 'North' or hit enter to get all locations. I can't figure out what the 'code' is behind this. Any ideas? Thanks.

 

[pr2-eugin]

It would be in the Query, somethng like.

SELECT someFields 
FROM theTable
WHERE theField Like Nz([Enter Location?], "*");

 

[Angel69]

Thanks, that worked nicely. How would I do it for a start and end date. Currently, I have

Between [Forms]![Main Menu]![StartDate] And [Forms]![Main Menu]![EndDate]

but want them to be able to press enter and not fill out a date in the form to see all.

 

[Brianwarnock]

Mydatefield Between [Forms]![Main Menu]![StartDate] And [Forms]![Main Menu]![EndDate] or Forms![main menu]![startdate] is null

You check to see if the parameter is null if it is then it will be for all records so all are selected for this criteria

Brian