I don't think any filters are set on. This is the recordSource i get after clicking the show all button in design mode - SELECT tblBookings.BookingID, tblBookings.MemberID, tblBookings.Classes, tblBookings.Day FROM tblBookings;

strsearch = "SELECT * from tblBookings" - This is the strSearch so it is quite different

Is there a way we can work this out together?