title: How to set the form record source to the first record returned in a record set?
body: <p>Im trying to set the first record returned from a record set to the record source of the form "Maintenance" How would I go about doing this? </p>
  
  <p>Why I'm doing is I've constructed a VBA code that finds all the records in a DB based on someones entry into a field - the results may be 0, 1, or greater than 1. How do I change the record set to the first record returned and then, when they press another button, move to the next record returned?</p>
  
  <p>thanks</p>