Autopopulating Forms

[daniel.e.john]

Hey all,
Let me start this off by saying that I am completely new to both Microsoft Access and VBA, but have been having an absolute blast trying to learn both as I go by creating a database for work. However, I hit a pitfall of sorts and am not sure if doing what I would like to get done is entirely possible.

My project is a tracker of students who can enroll in multiple certifications, take tests, and can subsequently get qualified for these certifications. As it stands now, I have a table that tracks the students basic information and a form that allows you to view this information... I can currently in the process of adding tables for the certifications and getting all the relationships correctly squared away.

What I would like to do, is eventually have the ability to view the student information form, click a box/button for a particular certification a student has, and upon doing so pull up a template-based form that will auto-populate with the information on that students certification that it can pull from a table or query (like their grade, comments, etc...).



Is this at all possible? Can you create a template form and have it auto-populate data based on a particular person's data on a particular subject? Any advice would help. Thanks for your time.

[tdecker81]

The short answer is yes. The students form you can easily have a listbox that shows all of the certs that that student has received, attempted, enrolled in but not completed whatever. Then with a single click bring up another form that will show you whatever detail you want to show on that record. This new form can link by cert type to a subform to show different questions or whatever.

PM me if you need help. I'm usually on at night and could connect and take a look over teamviewer if you want.

[tdecker81]

https://www.accessforums.net/sample-...zes-13082.html

Thought this example might help you.

[daniel.e.john]

Thanks for all the help, really appreciate it, believe it or not I managed to figure it out today thru simple trial and error over and over. I appreciate the offer of your personal time to have you connect via TeamViewer as well. Taking a look at the link to see if there is anything else I can get an idea of from it. Again, thanks so much and until next time.