Thank you both so much
With your help I finally worked out what to do, and found some other errors in my thinking, which should make the rest of the programming easier

Thanks again
Mand

----- Mandy wrote: ----

Please can someone tell me how to populate a combo box from a SQL query against SQL2000
Im using XL2000 and W2K. And should I be using activex or userform controls €“ is there a difference
Thanks for any hel