Missing Operator hunt

[corner40]

hi everyone
I have a missing operator in this bit of code:

[Forms]![f_adult].lstPreviousBooking.RowSource = "SELECT BookingHead.BookingHeadID, BookingHead.BookingDate, BookingDetail.BookingDetailID, BookingDetail.KID, " & _
"BookingDetail.SkiType, ActivitiesBooked.ActivityID, ActivitiesBooked.ProductID, " & _
"Product.LevelID, ProgramDescription.Level, ProgramDescription.Description " & _
"FROM ProgramDescription RIGHT JOIN " & _
"(Product RIGHT JOIN (BookingHead INNER JOIN (BookingDetail LEFT JOIN ActivitiesBooked " & _
"ON BookingDetail.BookingDetailID = ActivitiesBooked.BookingDetailID) " & _
"ON BookingHead.BookingHeadID = BookingDetail.BookingHeadID)" & _
"ON Product.ProductID = ActivitiesBooked.ProductID)" & _
"ON ProgramDescription.LevelID = Product.LevelID" & _
"WHERE ((BookingDetail.KID) = " & Me.KID & ")" & _
"ORDER BY BookingHead.BookingDate;"

if anyone can help me find what it is that would be great. I can't see it so I figure a fresh pair of eyes might help.
thanks
Jeremy

 

[RoyVidar]

You are missing a lot of spaces, for instance

"ON ProgramDescription.LevelID = Product.LevelID" & _
"WHERE ((BookingDetail.KID) = " & Me.KID & ")" & _

will produce

ON ProgramDescription.LevelID = Product.LevelIDWHERE ((BookingDetail.KID) = <somevalue>)

That's what I can spot on first glance.

Roy-Vidar