I'm trying to write a VBA program to add a new field to a MS Access database table, then to add the field as a text box on a form. I've figured out how to create the field with the code below, but is it possible to programatically add the field to a form?
Set db = OpenDatabase(sFileName)
Set tdf = db.TableDefs("theTable")
Set fld = tdf.CreateField("NewFieldName", dbText, 255)