Mulitple text boxes to different table from form

[cubicle]

I am using the following code to insert a value from a bound form to a different table:

CurrentDb.Execute "Insert into tblfavorites (employeeNumber) Values('" & Me.Employee_Number & "')"

Can someone help me with adding to this if I wanted to add to 2 different fields in a table from 2 different text boxes?

I cant seem to figure it out.

Thank you

 

[Andrzejek]

[tt]CurrentDb.Execute "Insert into tblfavorites (employeeNumber, OtherField) Values('" & Me.Employee_Number & "', " & OtherTextBox & ")"
[/tt]

But that all depends if you have a string (add single quotes around it), a number (no quotes) or a Data (add # around the date.)

But I would suggest doing it this way:

Dim strSQL as String

strSQL = "Insert into tblfavorites (employeeNumber, OtherField) Values('" & Me.Employee_Number & "', " & OtherTextBox & ")" 

CurrentDb.Execute strSQL

Have fun.

---- Andy