Help Please Problem With SQL1

Can you please help. I am having a problem with some sql that i copied from access into a variable. Everytime i run the program and click the button which uses the sql it crashes. See Pics below

http://img.photobucket.com/albums/v7...debugerror.jpg

http://img.photobucket.com/albums/v724/Dave_ed/code.jpg

Thank you in advance ATGE!

Just post code rather than screen shots.

You are missing some spaces in your sql statement. Common mistake when concatenating lines together.

VB Code:

MySQLTxt = MySQLTxt & " From..."
MySQLTxt = MySQLTxt & " Where..."
'instead of 
MySQLTxt = MySQLTxt & "From..."
MySQLTxt = MySQLTxt & "Where..."

ok! Sorry about that. Cheers for the help :thumb: