i posted this in the forms section by mistake as well.sorry. anyways i have a large sql select statement that is longer than one line. everytime i try to bring part of it over to another line by using the _ i get an error. what do i need to use to seperate this statement?please help

I usually split it over a few lines: e.g.

dim sqlstring as string

sqlstring = "the first bit "
sqlstring = sqlstring & "the next bit "
etc.

then pass the sqlstring variable into the openrecordset statement.

I've just answered it in the forms section! http://www.access-programmers.co.uk/ubb/frown.gif
Please don't post under more than one heading, it is a bit annoying to find you're wasting your time.

Ian