how do you break up long lines of code over multiple lines?
i thought it was just as simple as putting a _ at the end of the line
strSQL = "SELECT tblBudgets.* " _
"FROM tblBudgets " _
"WHERE tblBudgets.FundID = '" & variableName & "';"
if i put this all on one line, then it works fine. but when i try to break it up over several lines, then it turns red
also, how do i turn off that annoying msgBox that pops up every single time. I can see that the text is red and something is wrong. I dont need a message box to tell me every single time.