can I add new columns to table through forms

[pjustin1]

Hi, I need to add new columns through the input from the user through a form, is this possible? and can I later display all these added fields in another form?

Thanks
Justin

 

[Chris RR]

The first question is, "Why?"

What you need to make sure that you are NOT doing is something like, say, having the users add a column for "December" when they have December data to enter. If they need to do this, your tables are not structured correctly.

In fact, I am having a hard time figuring out a good example of when you would ever want to do this, unless you are building some kind of Access pre-processor...