Add New Combobox to table useing code

[Nigel]

I am using this code to add a new field to a remote table

dbs.Execute "ALTER TABLE orders ADD COLUMN chaincolor text(50)"

how would I modify this code to add the field as a combo box with the
following values, Metal and Stainless

thanks

 

[Douglas J. Steele]

AFAIK, you can't.

You can have lookup fields in tables (although most of us recommend strongly
against doing so: see http://www.mvps.org/access/lookupfields.htm at "The
Access Web" for some of the reasons), but you cannot create them using DDL.