Filter by Combobox, add ALL selection?

S

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
 
S

SusanV

Thanks Ofer,

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

Thanks tons,

SusanV
 
Top