I have a simple database in which users need to be able to add new fields
to
later down the road. I want to make a macro that will allow them to enter
a
new field name and the macro will copy the last field on the table, paste
it
underneath of that one as a new one, and then change the name to the one
entered. I want to do it this way for 2 reasons. All of the options will
be
the same between new and old fields and I some of the options (combobox
etc)
I don't believe can be set via SQL as I have to use Access 2000. What
commands in VBA would allow me to select fields and copy/paste them as a
new
row into the table.
Thanks,
Chase
