What I'm trying to do is make a textbox return the "classdescription" from a table where I use a combo box to select it. I managed to get the information to display for last name but it was only because the linked table had the field I need.
I have attached a picture of what I'm trying to do

You can assign the RowSource property of the combo to a query that associates both table (using an INNER JOIN). You can retrieve the value of a specific column from a combo using the following syntax: With n being the index of the column (0 for the first [leftmost] column, 1 for the second... etc.). You can hide the columns you do not want to see by properly setting the ColumnWidths property of the combo.