that's because it IS invalid syntax.
this should take away that specific error:
Code:
sql3 = "SELECT [Title],[Firstname],[Surname],[Address1],[Address2],[Wchair] FROM [" & table & "] " & _
"WHERE ([" & table & "].[Reg])=" & Reg & ";"
but the word "Passengers" is in your statement. what is that? gotta figure that out too. if it means nothing, or if it is part of the tablename, it should be included in the "table" variable anyway.
by the way, "table" is a reserved word in the access program so name your variable something else. you're going to corrupt your access files by using "table" as variable names.