Rowan Drummond wrote in
:

When you declare variables like this:
Dim test1, test2, test3 As String
only test3 is declared as a String. test1 and test2 will be assigned
the DataType Variant. UpdateAll is looking for a variable with a
string datatype.

Change your decleration to
dim test1 as string, test2 as string, test3 as string

or
Dim test1 as string
dim test2 as string
dim test3 as string

Hope this helps
Rowan

Gah! Yes, that helps.

fyb