Parent Table and Student Table. Autofill data if last name and first name exists in the database

[rb26dett26]

I am trying to make a form in access to register new parents with their students. The Student can be an adult or a child. The table will allow me to input new students without parents.

I want to set the form up to where I "Montgomery Rachel" already exists in the database with her information (phone# address etc) it will autofill that data.

For tblStudents
--- StudentId AutoNumber


StudentLastName Short
StudentFirstName Short
Age
Phone#
Email
Address
ParentId_FK



For tblParent/Guardian
guardianId_ PK
Guardian1_last Name
Guardian2_first Name
PhoneNumber_1
Guardian2_last Name
Guardian2_first Name
PhoneNumber_2
Email
Address

Would I have to use a query to get the results?

I have looked online for a guide but most only use the Id to where the user inputs the Id and gets the autofill data. I like to autofill the data via their last name and first name

[aytee111]

The name will be selected from a combobox, correct? The first column in that combobox will be the StudentID, use that to set a filter and requery the form.