Hi all, I dont what is command to request the value from table and display them in textbox.

This what I have (Access);
Table Name :
- Member_info

Attributes :
- MemberID, MemberName, MemberAge.


AdodcMember(recordset)

I want to display MemberName(Attribute) in txtName(textBox) where MemberID(Attribute) equal to 1234 (Key in by user in VB)

Please give me some guide how to do this.