Combobox with a little twist

[Daniel P]

Hello

Is it possible to have a combobox list all the items from a specific field in a table and also such items as "Not Applicable"

I want to list all the items in the status field of my table but also want to offer certain other options such as "Not Applicable"

Thank you for your help

Daniel

 

[M Skabialka]

I just did that myself:

SELECT "ALL" AS CN, "All Contracts" AS DESCR FROM tblContract ORDER BY
tblContract.ContractNumber UNION SELECT DISTINCT tblContract.ContractNumber,
tblContract.RateName FROM tblContract;

Combo results:
CN DESCR
== =====
11845 CCA
11921 CAS
ALL All Contracts


If there are a bunch you could put them in another table and UNION that
instead.

HTH
Mich

Hello,

Is it possible to have a combobox list all the items from a specific field

in a table and also such items as "Not Applicable".

I want to list all the items in the status field of my table but also want

to offer certain other options such as "Not Applicable".