Adding data to a table

[June7]

From your last post I cannot understand specific issue now facing, if any, or do you mean that these behaviors are working satisfactorily?

[Jbelle7435]

From your last post I cannot understand specific issue now facing, if any, or do you mean that these behaviors are working satisfactorily?

sorry for the delay. Right now I do not have multiple inputs into a table working. If I could finish that up then I will be on my way!

Got this: One textbox. One click, insertion into a table per ID. Over and over
Do not got: Multiple textboxes. One click, insertion into multiple columns of that ID. Over and Over.

[Jbelle7435]

Private Sub Command4_Click()
Dim db As DAO.Database
Set db = CurrentDb
db.Execute = "INSERT INTO Table1 (Part_Name, Revision) VALUES ('" & txtPart_Name & "', '" & txtRevision & "')"
End Sub

I get an ERROR that states.
"Compile Error", Argument not optional. It highlights the the txtRevision ?? in the 4th line near the end