create a subform on the main to display the results of the second query. you will need to requery the sub form after the user make the selection on the main form.
For clarification, in my first post I said the results of my query appear on the main form in a text box. They actually appear in a list box.
Here are the steps I took.
01). I have a main form called COMPANIES. It is based on a query of the same name. I opened the form and I see the results of my query in the list box (LIST0). The list consists of three columns. Column 1 has the Company ID, Column 2 has the Company Name and Column 3 has the Company Address. Column 1 is bound so that value can be used by another query.
02). I created a form called LOCATIONS. It is based on a query of the same name. It uses the ID from the form COMPANIES and it displays the individual store locations for the select Company.
03). On the main form called COMPANIES, I used the tool wizard and added a subform that calls the form called LOCATIONS.
04). Now when I open the main form called COMPANIES I see the list of ID's and Company Names. the subform for LOCATIONS is empty.
05). In edit mode I go to the properties of LIST0. I find the OnDblClick.
During Testing
A) I have been able to add an event procedure that when the operator double clicks the Company ID the results of the query LOCATIONS appear on the screen. This is done my using the DoCMD.OpenQuery
B) I have been able to add an event procedure that when the operator double clicks the Company ID the results of the query LOCATIONS appear in the form called LOCATIONS. This is done using the DoCMD.OpenForm
Here is where I get lost, how to I get the results of the LOCATIONS form/query to appear on the same screen and the COMPANIES form/query