How do I setup a Combo box list that has (None) as a pick

  • Thread starter Thread starter Linda
  • Start date Start date
L

Linda

I need a combo box that has a list from the ContractNum
field in the Contracts table. That works fine, but
sometimes they do not want a ContractNum selected yet.
They will fill in everything else and select a ContractNum
later. (not the PK) How do I ceate a (None) selection or
blank selection?
 
On the combo box set the Row Source Type to Table/Query.
Set the Row Source to:

SELECT Contracts.ContractNum from Contracts UNION
Select "(None)" as BogusContractNum FROM Contracts
ORDER BY Contracts.ContractNum;

This will like put (None) as the first selection in the
drop down list, followed by the rest of the valid contract
numbers. Let me know if this works.
 
Back
Top