Hi, I have a problem regarding combo boxes. I want to add a combo box to a form such that when any item on it is selected the remaining text fields on the form are automically filled from a table depending upon the selected item.

For example, if the combo box has a list of products. When the user selects a particular product and presses go, the text fields on the same form are filled up with the product details (by looking up a table based on the selected product). I am a looking for a solution without the use of subforms.

Thanks