Search form to show a list

Hi everyone,

So I've started to use MS Access for database logging, I've managed to make a simple form to store a person's name, grade & training (with dates and status) now I'm trying to find how to make a search form that a user would be able to choose a name from the database (only ones that were already added) and then the search form would show what trainings the user has had, on what day and what is the status.

Is this possible to be done in base of access or is VBA required?

Thank you

You would do this building a query using the table that is bound to the form as the record source.

https://edu.gcfglobal.org/en/access2...imple-query/1/