Unanswered: Textbox returning value based on object
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:
MyTextBox.Value = MyCombo.Column(n)
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.