If your code needs to span over several lines, however it should all execute as one line then use an ampersand followed by a space followed by an underscore (& _) at the end of the line before beginning the next line. For example, change your code to look like this:
Code:
strQuery= "INSERT INTO tabelename(lastname, address.............) " & _
"values ('"&a_lastname&"', '"&a_lastname&"',..........)"
Notice that you have to close the string before using & _ and then open the string again on the next line.
Regards
Owain Williams