Adding 'All' option to combo box

[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?

 

[Bas Cost Budde]

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?

rowsource for the combobox:
select yourfield from yourtable UNION select distinct "(all)" from yourtable

You need handling for the (all) selection