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!