SOLVED MqSQL With VB front end, entering info

[joefox]

Another quick question..when i hit the "Update button" i want my caption to say there first and last name + Updated.

Dim strSql As String
'---- create an sql statement that returns no data (as false <> true)
    strSql = "SELECT [First_Name], [Last_Name], [Age] " _
           & "FROM [JoeFox] " _
           & "WHERE 1 = 2"
'---- Open the recordset
    Set rst = New ADODB.Recordset
    rst.Open strSql, oConn, 3, 3, 1 'static,optimistic,adCmdText
 
    AddUser = True
    With rst
        .AddNew 'adding new record
        .Fields("First_Name") = sFirstName
        .Fields("Last_Name") = sLastName
        .Fields("Age") = SAge
        .Update 'this updates the recordset
    End With
    Label2.Caption = "sFirstName" + " " + "sLastName" + "Entered..." ' THIS JUST PRINTS THE WORKS sFirstname :(
 
    ' Closes the Record set so that it dosent us up memory space
    rst.Close
    Set rst = Nothing
 
End Function