<ALL> Option in Combo box

[abbaddon223]

Hi - I've seen qutie a few posts on this, but I just cant seem to get my head round things and would really appreciate some help!!

I have a combobox: "Combo_View_As"

This sits on a form and get's it's datasource from the table: "luAutorisedUser" and the field: "AuthrisedUser"

This gives me a list of names in my combo box, IE:

Name1
Name2

I have a series of select queries that use the combo box as a parameter value (IE the name of the person) to run the query (the query is "Slc_Pipeline")

On the form is a chart which users the query as an control source. So, when I change the name in the combo box, the refreshes the query and the chart - lovely stuff....

However, I'm really trying to find a way to have an ALL feature in my combo box that when selected would effectively select all, and the query would give the result for all people - is this possible?

Help VASTLY appreciated!!!!

 

[pbaldy]

You could combine these two:

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

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

 

[abbaddon223]

Yep - that did the trick - thank you very much indeed!!

 

[pbaldy]

Happy to help!