copy a column and it's properties

[seiky]

hello,
I wanted to know how to copy a column and it's properties by programming (VBA-SQL).
I have a column that has a list of values, and want to duplicate it (with another name).The new column should have the same list of values.

thanks for reading.
Seiky

 

[neileg]

I would do this with an update query, assuming this is a bulk process. If you want to do it on data entry, you'd do it in a form.

I'm puzzled as to why you want an exact copy of existing data, but it's your database.