Linking Queries to a form in Access

Hi Community,
I'm working on a new project and the team uses forms in access. I am trying to learning how to build/link queries to forms. I'm just a beginner at this level. I'm looking for basic information for now.

I am trying to build the form to return the birthday of the last name I selected. See attached.

Thanks.

see attached examples.

Originally Posted by alansidman

Having presented a word document (basically a picture of your form) is not helpful at all. Uploading your db showing your query and the form and describing what you want to happen would be more beneficial. I don't want to try and recreate your db. I don't have time. We are all volunteers here. Help us to help you by showing us sample data in real live database. You will need to be more specific in your request. Are you trying to get queries to run based upon information in your form/table? Are you trying to populate a form based upon a query? Really, what are your doing? How are you selecting the Name? Where?

I tried to put the actual access database sample file but got error message .accdb not allowed. Which is why I put a picture. Since I don’t know forms very well. I tried to put a picture of what I’m trying to do.
Upon further research. My quandary is the following;:
How to write the query in forms to load the information in the desired unbound box. If I can get one field to work I’m sure I can figure the rest out. So do I just need to put the excel file with the data and you can help me with creating a form in access?

Originally Posted by alansidman

Having presented a word document (basically a picture of your form) is not helpful at all. Uploading your db showing your query and the form and describing what you want to happen would be more beneficial. I don't want to try and recreate your db. I don't have time. We are all volunteers here. Help us to help you by showing us sample data in real live database. You will need to be more specific in your request. Are you trying to get queries to run based upon information in your form/table? Are you trying to populate a form based upon a query? Really, what are your doing? How are you selecting the Name? Where?

I’m trying to populate form based on a query.

Thank you Alan,
For your help. Please see the attached zip file.

Hi Alan,
Thank you and sorry for the delayed response.
I will look into that. This is all new, so I don't have a preference at this point. My data is based on results from queries. For example "How Many users are logged on from the three location. So to get that, I run the query to determine that
25 users are from Houston, TX
35 users are from Miami, FL
40 Users are from Columbus, OH

These results are then populated in the form.

Is that capable from your suggestion.