I'm working on a database that will track, among other things, information about students enrolled in a nonprofit's afterschool programs. I'd like to have a form that shows every record in the People table, along with a few key details (name, birthdate, gender, etc.) The user could then click an "Edit Record" link to open a form with several tabbed subforms to allow them to interact with all of the data in the record.
The Students.accdb example database that I downloaded has several examples of exactly what I want to do, but I haven't been able to figure it out so far. (See attachment.)
Could someone post a step-by-step walkthrough of what I need to do? I have Googled extensively on this, but I think I don't know enough about Access to phrase my queries properly on this one.
Thanks,
Josh