I have a form based on a table containing customer information.  The form also contains a combo box so that I can pick a country.  I created a query using the value in the combo box that pulls information from a second table.  The query works fine and displays the correct data in the query's datasheet view.  However, what I want to do is populate a sub-form with the same data.  I've tried pointing to the query in the sub-form's Record Source, but that does nothing.  So, how do I take the results of a query and populate a form?  Many thanks!

---

Reply from Richard Rost:

So you want to pick a customer in a combo box and then have the rest of that customer's data displayed in a subform, or are you trying to COPY that customer's data to a new record in the subform?