combo box events. loading another text box upon the values of one.

[saleemMSMS]

please refer the following table

i created a form to the above table.
participant group names are loaded into a combo box.

another text box is assigned to the participantGroupType Column

what i want is when a person selects the type name, the relevant type should be entered to the text box.

how an i do that ?

 

[missinglinq]

You need to load the participantGroupName field and the participantGroupType field into the combobox, then use this code:

Private Sub ComboboxName_AfterUpdate()
 Me.GroupTypeTextBoxName = Me.ComboboxName.Column(1)
End Sub

inserting your actual names, of course.

 

[saleemMSMS]

thanx alot buddy