title: button to find record in another table based on field
body: <p>On my form, i have a button beside a field (AppID) thats linked to records in another table (Applications).</p>
  
  <p>Is there a way i can set that button to open the Applications form and bring up the record stated in the AppID field? it would make my life ALOT easier</p>
  
  <p>im using Access 2010</p>
  
  <p>thanks!</p>