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