Coding the AddNew command button

[tshimega]

Hi,

 

I have a form in VB 6 called frmEMPLOYEE with 3 textboxes namely: First_Name, Last_Name and Employee_Id . I also have a table in access called tblEMPLOYEE. How to I create a button to take whatever that I have on the text boxes and puts in into the database.

 

"I have already set the connectionstring and set the recordsource and the built process was successful."

 

I have tried:

 

 

Private Sub Command1_Click()

 

Dim Rs As Recordset

 

'Set Rs = CurrentDb.OpenRecordset("tblEmployee", dbOpenTable)

 

Rs.AddNew

 

Rs("Employee_Id").Value = Text3

Rs("First_Name").Value = Text1

Rs("Last_Name").Value = Text2

 

Rs.Update

End Sub

 

But this doen't help. Again how do I link the application with the database. I am using access 2000 and VB 6

 

Thanks

[PlausiblyDamp]

You are probably better off asking VB6 related questions over at our sister-site http://www.xtremevbtalk.com/