Insert Into statement

[TamworthBob]

Hi
Is there a way to get the following to insert the value of the Ints? (eg IntSurname) I want say "Robinson" not IntSurname

et dbs = OpenDatabase("S:\Data\WirelessComponentsData.accdb ")

' Create a new record in the DistributorContacts table.
dbs.Execute " INSERT INTO tblDistributorContacts " _
& "(DistributorContactFirstName,DistributorContactSu rname, Phone, Mobile) VALUES " _
& "('IntFirstName', 'IntSurname', 'IntPhone', 'IntMobile');"

dbs.Close


Thanks
Bob

[June7]

Concatenate variables.

dbs.Execute "INSERT INTO tblDistributorContacts " _
& "(DistributorContactFirstName, DistributorContactSurname, Phone, Mobile) VALUES ('" _
& IntFirstName & "', '" & IntSurname & "', '" & IntPhone & "', '" & IntMobile & "')"

Why have you declared string variables with Int prefix?

[TamworthBob]

Thanks, works great
I guess I have got a little lazy with my declarations...thanks for the kick in the butt
Bob