I have build a simple MS Access database to keep track of volunteer info (contact, address, phone etc). I have a report that displays each record in a list:
record1. Last Name, First Name, phone, email
record2. Last Name, First Name, phone, email
What I want to accomplish is to have either the Volunteer's name in this record be a Link or add a link itself to the recod that when you click it it takes you to an individual detailed report that will display more accurate information about the volunteer.
I know I can create a button and link it to a different form/report/query... but I am not sure this will work as intended since the report does not show all the volunteers rather the ones that meet a specific criteria, therefore Ineed this to be available for every single record regardles of the report or query that is being run.
I built a form that displays all the detailed information of the volunteers and you can scroll through it to view them.... is there a way the link can actually point to this form, but the form shows the actuall volunteer selected instead of the standard default first volunteer?
Any help and ideas will be greatly appreciated.