Add 2 items to Combo box

[KIT LAU]

Hi,

I would like to add "(ALL)" and "(Blank)" to a Combo box.
How can I do this?

Thanks in advance,
KIT LAU

 

[Arvin Meyer]

Here's one way. Use a SQL statement similar to the one below as the
rowsource:

SELECT "<All>" as ID, "" as Location
FROM tblLocations
UNION SELECT ID, Location
FROM tblLocations
ORDER BY Location;
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access