Combobox with a little twist

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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


Daniel P said:
Hello,

Is it possible to have a combobox list all the items from a specific field
Click to expand...
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
Click to expand...
to offer certain other options such as "Not Applicable".
 
Back
Top