About Access forms

[Ancikam]

Hi
my name is anas and my question is how can we link things in forms

e.g I have member id as combo box for 30 empolyees and i want when i select the member id the rspective member name automatically comes in the text box which is infront of the member name lable plz help me
i have a project to submit in 4 days and i need your help
plz reply to me on my account:
[Deleted E-mail]


BYE

[Rabbit]

You need code in the After Update event of the combo box.

Private Sub Combobox_Name_AfterUpdate()
  Me.TextBoxName = DLookUp("[Field Name]", "[Table Name]", "[Member ID] = '" & Me.[Combobox Name] &"'")
End Sub