Hi
Check out Candace Tripp site for a demo called:
ComboBox - Polulate Form.
QUOTE
This demo shows how to populate a form and/or text box controls based on the user's selection from a combo box. The demo shows five methods of populating text boxes based on a combobox including: DAO, ADO, Filter, DLookup, and Combobox column values.
HTH's