Updating my table through VBA.

[pedie]

have a Table called is Mytable & Form2 which has Name (textbox renamed) and text2. I have a button when clicked, i want the name info & text2 values to be updated in table1 col 1 and two. Col 1 name/header = Name & col2 = "EMP IDS".



Thanks for helping. Very new so I have explained in detail. Hope someone can help. Thanks again

Private Sub Command4_Click()
Dim x As String, y As Long
x = Me.NameT.Value
y = Me.Text2.Value

Mytable("Name").Value = x
Mytable("Emp IDS").Value = y
Mytable.Update
End Sub

[ivancp]

You can use SQL:

Private Sub Command4_Click()
    Dim x As String, y As Long, strSQL as String
    x = Me.NameT.Value
    y = Me.Text2.Value
    strSQL = "UPDATE Mytable SET Name = '" & x & "' ,  [Emp IDS] = " & y
    currentDb.Execute strSQL    
    End Sub