I have a command button set up on a form to run a SQL pass-through insert query after several field are filled in but I can't get the variable syntaxs correct..

I have tried..

INSERT INTO Response (Equipment_Type, Equipment_Name, Alarm, Alarm_Status) VALUES ('[type]','[name]','[alarm]','[status]')

INSERT INTO Response (Equipment_Type, Equipment_Name, Alarm, Alarm_Status) VALUES ('[Form2]![type]','[Form2]![name]','[Form2]![alarm]','[Form2]![status]')

INSERT INTO Response (Equipment_Type, Equipment_Name, Alarm, Alarm_Status) VALUES ('Forms![Form2]![type]','Forms![Form2]![name]','Forms![Form2]![alarm]','Forms![Form2]![status]')

And none of them work, they all pass the variable syntax but not the value of the variable. Any suggestions?? Thanks in advance.

I take it they are all text fields, if so try
Dim SQL As String
SQL = "INSERT INTO Response (Equipment_Type, Equipment_Name, Alarm, Alarm_Status) VALUES ("
SQL = SQL & "'" & Forms![Form2]![Type] & "'" & "," & "'" & Forms![Form2]![name] & "'" & "," & "'" & Forms![Form2]![Alarm] & "'" & "," & "'" & Forms![Form2]![Status] & "'" & ")"
db.Execute (SQL)

phil