I have asked this before and didn't really get any help and it was left unanswered. Any help would be greatly appreciated.

I have a dropdown list that is populated with a field from my recordset. I also have text boxes on my form from the same recordset that compose of the other fields. When I select a value from the dropdown, it doesn't populate(update) the rest of the text boxes on the form. I don't have any code written because I am under the assumption that once I pick a record from the dropdown-combolist box, it should populate the rest of the fields. Is this a wrong assumption? If it is, could someone tell me in detail(code) how to populate those other fields.