title: Filtering MS Access subform with vba
body: <p>I have a quick question. I've developed a booking system that has a sub form containing all the rooms booked on the date displayed (in main form). I've added a combo box to allow users to filter the rooms to only see the ones they select from combo box (re-query the sub-form and then filter).</p>
  
  <p>This works fine apart from the fact my code would sometimes loop through the filtering sub for no apparent reason after reaching the end of the sub?. It displays everything correctly, so this I'm not bothered about (unless it's connected to the real problem).</p>
  
  <p>The real problem I'm having however is when I choose a room that has no bookings for the date displayed. The filter works fine (empty display), but when I then try to choose another room from the combo box the re-query function behind the after update of the combo box does not work!</p>
  
  <p>Has anyone else experienced this before?</p>
  
  <p>The workflow:</p>
  
  <p>Combo box triggers 'after update' event. This re-queries the sub-form, where behind the 'on current' event the filtering of the sub-form happens.</p>
  
  <p>When sub-form is empty I'm unable to perform any further sub-form re-queries.</p>