Subform updating a Combo box

[Shirley]

I have developed a form with three tabs. On the last tab the user wants all students <br>
with the same LastName. I've set that up, but now he wants to be able to use that <br>
list to update the other two tabs. Should I use requery the combo box, or update the <br>
fields in the other two tabs, or use some type of VB coding. Give me your opinion.<br>
<br>
<br>

 

[Shirley]

I have fixed the problem.

 

[Varja]

How did you fix the problem???

 

[Shirley]

When the user select the Person, I set up a button that when pushed it would update the other tabs. <br>
<br>
#<br>
"Selecting a particular student<br>
Private SUb Select_Click()<br>
'Find the record that matches the control<br>
If NOt IsNull([Student Last Name Subform]_<br>
.Form.StudentID) Then<br>
DoCmd.FindRecord[Student Last Name Subform] _<br>
Form.StudentID<br>
End If<br>
End Sub<br>
<br>
This allowed me to select from the third tab and it updated the other two tabs.<br>
<br>
<br>