debug.print the sql statement before you send it to the rst... then post that here (or fix it if you see something wrong).

I guess that it may be the date field as Sql statements are in us format, and certain date cause probelms.

One fix would be to put this in :
Code:
WHERE (BookingDate=#" & format(BookingDate,"dd mmm yyyy") & "#) " _