title: How to show all records in the form from the table for the same given ID
body: <p>I am working on Access forms(unbound). I have a question that I want to search records in the table by the field [ID]. When there is only one record in the table for the given [ID], form shows that record, its fine. But if there are multiple records for the given [ID], form still shows the first record and not showing the other records.
  I want that form should show all records for the required [ID] in such a way that i can navigate through all records in the form view.</p>
  
  <p>The SQL statement i am using is :
  strSQL = "Select  * from [myTable] t where t.[ID] ='12345'
  myTableRS.Open strSQL, Conn, adOpenDynamic, adLockReadOnly, acCmdText</p>
  
  <p>I tried for using row_count fn in access sql but its generating error.I think due to not compatibility.
  I don't want to use auto generated field in the table, its a requirement.
  Kindly help me how to fix it 
  Thanks in advanced.</p>