set data to the textbox when i select value from combobox.

[billypit]

Hi,
I am totaly new to MS Access.

I have one form in MS Access in which i want that whenever i select an item from combobox then in the textbox on the same form or subform i want value from table based on selection from combobox.

like
in my table there two fields
ID,name
1 billy
2 sandy
3 john

so in form i have 2 field like One combobox for select ID and one textbox for name.

so whenever i select ID from combobox it will directly set the value of textbox
like if i select 1 from combobox then it have to show me billy in textbox.

[Rabbit]

Hi,
I am totaly new to MS Access.

I have one form in MS Access in which i want that whenever i select an item from combobox then in the textbox on the same form or subform i want value from table based on selection from combobox.

like
in my table there two fields
ID,name
1 billy
2 sandy
3 john

so in form i have 2 field like One combobox for select ID and one textbox for name.

so whenever i select ID from combobox it will directly set the value of textbox
like if i select 1 from combobox then it have to show me billy in textbox.

This creates redundant information. You only need to store the ID. But in the combo box, you can show just the name while storing the ID.