Dao

[Ricky1]

Ok i have a combo box that is suppose to fill in the other fields.
I have got this code to fill the combobox but how do i male it fill in the other fields ????

Private Sub Form_Load()
    Data3.Refresh
    With Data3.Recordset
        .MoveFirst
        Do Until .EOF
            cboMembershipNo.AddItem (.Fields("MembershipNumber"))
            .MoveNext
        Loop
    End With
End Sub

that works fine, i just need to know how to make it fill in the relevant information.