Adding 'All' option to combo box

  • Thread starter Thread starter Steve Price
  • Start date Start date
S

Steve Price

Hi,

I want to have a combo box on a form which pulls its data
from a table. In addition to this I want it to have
an 'All' option.

Is this possible, and if so how?
 
Steve said:
Hi,

I want to have a combo box on a form which pulls its data
from a table. In addition to this I want it to have
an 'All' option.

Is this possible, and if so how?
Click to expand...
rowsource for the combobox:
select yourfield from yourtable UNION select distinct "(all)" from yourtable

You need handling for the (all) selection
 
Back
Top