All records in combobox

[cmweb via AccessMonster.com]

I've designed a form to register the parametros of a world-wide statistic
report
In the form I have a combobox to select by pais, but additionally I need the
option 'ALL' for to inform about all countries
How I can include the option ALL in the combobox ?
Thanks a lot
CM

 

[Brian Bastl]

One way is to use a union query as the rowsource for the combo. The details
you'll find at the following link:

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

HTH,
Brian

 

[Guest]

There are a couple of ways. An easy way is in your query that is using the
combobox as parameter make the criteria like this --
Like [Forms]![YourForm]![YourComboBox] & "*"
Add a control tip that says to omit selecting anything for all.

Another way is to add to the combobox data source an ALL with unique
asignment such as 999 if you are using numbers or XXX if text. Then in the
query use an IIF statement in the criteria for the ALL or selection.