Prive Sub AddColumn_Click()
CurrentDB.Execute("ALTER TABLE ADD COLUMN NewField Text(30);")
This above works but I want to replace NewField with Me.TextBox1.Value so that user can type in a name in textbox on form and add as a field.
Also will like to replace Text(30) with Me.Cbo.SelectedValue.
I know letting users add fields is not great idea but until I manage to talk them out of it...........
Thanks!!!