Filter by Combobox, add ALL selection?

[SusanV]

How can I add an ALL option to a combobox I'm using to filter a subform? The
combobox is based on a SELECT DISTINCT query, and I don't want to add an ALL
record to the table... this is probably incredibly simple, but I simply
can't get it!

=/


TIA,

Susan

 

[Guest]

Check this link on "Adding "All" to a listbox or combobox"

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

 

[SusanV]

Thanks Ofer,

This is working perfectly now! Major brainfart, didn't even think of using
a UNION query, doh!

Thanks tons,

SusanV