title: Subform only shows single record
body: <p>I have a subform(Users subform) embedded in a form(users). What I am trying to achieve is on load, the subform should show ALL users in the table and the controls on the main form to act as a filter.<br>
  i.e.<br>
  if user A is selected from a combobox in the main form, only User A's details show in the subform<br>
  if the selection (ie userA) is cleared from the combobox in the main form, ALL records will popup again in the subform. </p>
  
  <p>This sound very simple but for starters, when I load my form, only 1 record is showing in the subform, If i make a selection in the user combobox, then that user's records show ONLY. It defeats the purpose of having a subform if all I can see is one record it a time with or without making a selection. </p>
  
  <p>I am using Access '03. Can anyone help with this. I have a sample database here that has managed to achieve this but I cant seem to find a difference in their settings compared to mine. </p>