Hi,

I  am burning my brain up trying to do something I thought would be so simple that I must be the simple one – I want to use an InputBox in VBA 6.5 (in Access 2002) to accept a piece of information from the user of a form. I then want to use an SQL statement in the VBA to be able to insert the information into a table. I have tried every combination of single and double quotes, brackets and parenthesise around the variable “NewTestingActivity” in the SQL statement, but the best I can achieve is a prompt box to pop up with the Sub below. To your experienced eye it will be obvious what this novice is doing wrong…

Dim NewTestingActivity As String

Private Sub for_all_leas_Click()
NewTestingActivity = InputBox("Please enter the name of the new Test Activity:", "New Test Activity")
DoCmd.RunSQL "INSERT INTO TestingActivities (TestingActivityDescription) VALUES (NewTestingActivity);"

Many thanks in hope

Tim

---

Answer from Richard Rost:

Try:

DoCmd.RunSQL "INSERT INTO TestingActivities (TestingActivityDescription) VALUES (" & NewTestingActivity & ");"

And if that doesn't work, add quotes:

DoCmd.RunSQL "INSERT INTO TestingActivities (TestingActivityDescription) VALUES (""" & NewTestingActivity & """);"