It was actually on a single form but i changed it to continuous since the membership form is continuous too.

The query shows all the records however it doesn't show all of them in a list when I click 'show all' button. I have to use the record filters and click next to view the other records.

Could it because I am searching by member ID or Booking ID, the Dim strSearch should be an integer since we're typing numbers and not text?