Search results

yes im sure spellings are correct, they were copied/pasted from SQL view in query builder .List0.RowSource = strSQL7 That is the line it keeps highlighting

again thanks for your reply,tried the code & no change, still getting the error ps it would be hard to change the table name Required because it is a huge part of the project, but its almost done and this is the last bit so i cant imagine it being a big problem

Thanks for your reply david, ive tried the code but am still getting the error, it seems to be highlighting the .List0.RowSource = strSQL7 line, which makes me think its something in the SQL statement but i have no clue what it is :confused:

Hello all, fairly new to VBA/SQL but i know a little bit stuck on this problem Dim Opt1 As String Dim strSQL7 As String Opt1 = Option1.Value If Option1 = True Then strSQL7 = "SELECT Booking.BookingID, Booking.TeacherInitials, Booking.RoomAddress...