Adding [All Records] as an option in a query criteria.

[Robbyp2001]

Good morning folks.



I have a drop down list on a form which is linked to a query containing all records IDs. The selection made in the drop down list will return one record, correctly and this is then viewed on a different form. This part works well. What I would like to do is to give the user the option of selecting a single record from the list or to select ALL the records on the list which will then be displayed on the same form. The idea is to allow the user to scroll through the records if required.

I have done this before by adding something to the criteria in the underlying query, but for the life of me I cannot remember what it was.

Anyway the simple criteria currently in the underlying query is this:

[Forms]![Select Student Record for Edit]![Combo0]

This of course will return only the secord selected from [Combo0], how to I add 'All Records' as a user option?

Thank you in advance for any suggestions.

Rob

[pbaldy]

One option is to have the user leave the combo blank and do this:

http://access.mvps.org/access/queries/qry0001.htm

or use that technique with this:

http://access.mvps.org/access/forms/frm0043.htm

[Robbyp2001]

Wonderful Paul. After creating a new table with all the ID numbers plus a new entry "All Records" with an ID=0 then running the query from that as per your example, it now works a treat.

Many thanks, you're a star!

Rob

[pbaldy]

Happy to help Rob!