button to find record in another table based on field
===

On my form, i have a button beside a field (AppID) thats linked to records in another table (Applications).

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

im using Access 2010

thanks!