combo box - query result plus fixed value

[excession]

I have a bombo box which is populated with the result of a query "select manufacturer from tablename" which list all possible manufacturers. How can I easily add an ALL option to the combo box list?

 

[ZmrAbdulla]

Adding "All" to a listbox or combobox

________________________________________________________________________
Zameer Abdulla
Visit Me
No two children are alike - particularly if one is yours and the other isn't.

 

[KenReay]

HI

SELECT Manufacturer FROM tblManufacturer UNION SELECT "<All>" As A FROM tblManufacturer ORDER BY Manufacturer



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[excession]

perfect, worked a treat, thanks