Add columns

[Jengo]

Code:<br><br><br>&nbsp;&nbsp;&nbsp;&nbsp;Dim MyDB As Database, MySet As Recordset<br>&nbsp;&nbsp;&nbsp;&nbsp;Dim temp1, temp2 As Variant<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Set MyDB = CurrentDb<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Set MySet = MyDB.OpenRecordset(&quot;Problem Types&quot<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Add Code here&nbsp;&nbsp;&nbsp;&nbsp;<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MySet.Update<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MySet.Close<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MyDB.Close<br><br>Where it says &quot;Add code here&quot;, I want be able to add a new column to the table on the end, and get the name from a textbox.

 

[DougP]

your doing it backwards<br>You need to create your table and use a form wizard to make a form from your table. Not make a form then create a table to match it.<br>See Access has wizards that automate things andd they need to occur in a certain order.<br>Other wize you are constantly fighting or writing code to do what other wise is a no brainer.<br><br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[Jengo]

I already have the form and table made I am trying to add another column to the table at run-time.