Originally Posted by
Gicu
Make the combo's row source include the other relevant fields (FirstName, MemberID) then bind your textboxes where you want to show them using the .Column(index)
Lets say your combo's row source is a query with three fields (SELECT MemberID,Surname,FirstName From Members) with the first column hidden (column width=0); so when you select a Member you see the surname as the first visible column; for the other two textboxes add as their control source:
"=[cboMember].Column(0)" for the MemberID
"=[cboMember].Column(2)" for the FirstName
Obviously adjust for your own control\field names.
Cheers,