Creating a Query based on table values

[ramhanuman]

I am working on an absence database project for employees in an office. I have a form with the following list of absence codes:

The user first creates all the employees and then as the days go by can edit their profile and mark down absences based on specific reasons from the above choices. Now I want to present the user with a table/query, I'm actually not sure which one I should use, that shows a list of absences sorted by absence codes. So I want to present a table/query that looks much like the picture above, but has a little + next to each description so the user can click and see the list of people who have missed work because of that specific reason. How do I do this? Thank you

 

[Brianwarnock]

It would seem that you should create a form with a combo or list box based on your table of values. A query would reference the combo in it's criteria and a form could be based on the query to display the data. A command button on the first form would open the display form causing it all to happen after the users selects a value from the combo.

Brian