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

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

 

[Chaplain Doug]

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.