populate form fields based on combo box selection

[Mamaestes]

I've been reading through the other requests and trying to follow along, but
I'm having trouble...

I have two tables - Persona Data and Incident Reports

I want the data entry clerk to use a combo box to select a student
This combo box (which works) pulls the student ID (bound) and shows the
student first and last names.

Then...and this is where I have trouble...I want the student's First and
Last Name to populate those text boxes on the form (but not be bound to the
table...as I don't wish to duplicate data and want to use the Student ID
field as the common identifier).

When I click on the Student ID field in my Incident Report form, I can view
the combo box with all three fields displayed (Student ID, First Name, Last
Name)...and when I select a name, it populates the field (and the Incident
Report Table) with the Student ID number. But I can't get it to display the
first and last names in their text boxes.

I'm sure this is a simple fix, but I've been at it so long I'm ready to pull
my hair out!
Help! What other info can I give to help you help me? Please...I'm desperate
and need to get this done!

 

[NetworkTrade]

make your first name unbound text box to have the control source:
=ComboBox.Column(1)

make your last name unbound text box to have the control source:
=ComboBox.Column(2)

the numbers can correspond to any columns found in a combobox.....the first
column is usually (0) though I think that rule changes to (1) in the most
recent version...can't remember at the moment....but overall this is the
idea....