refresh query from FORM

[zadjali2000]

Hi guys,
here's my problem:
I got a form where i'll choose the member id from a combo box , now what i need is whenever i choose an ID from my combo box the corresponding name will appear in a text box below that combo box. The data are brought to me from a query(or it can be from a table).

so can u help me please???

 

[doulostheou]

If you setup a combo box using the wizard, it walks you through finding a record on your form based on the value selected in the combo box (the 3rd option). It will then write the code that accomplishes this for you.

This is the Access generated code where Combo0 is the combo box:

Sub Combo0_AfterUpdate()
    ' Find the record that matches the control.
    Me.RecordsetClone.FindFirst "[ID] = " & Me![Combo0]
    Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub