Display results on subform based on a query from the main form

[hunsnowboarder]

Hi there Everyone!



I am going crazy with my problem.

I have a database of companies and their ownership in other companies. I would like to make a form where I can select a company from a drop down menu and once selected I get the results in a subform.

Half of it is working OK but I have problems with displaying the results.

I have a main form called "Lekerdezes_urlap". On this main form I have the drop down menu of available companies. When I select a company in the combo box a query () will run selecting the relevant companies.
My problem is that I do not know how to display the data on this form.
So far I have the query and a subform of the query. However I do not know how to display it results in the query. My code to the drop down is very simple:

DoCmd.OpenQuery "Lekerdezes_teljes", acViewNormal, acEdit

This displays the query with the valid results. The subform for this query is "Lekerdezes_teljes". However when I select a company on the drop down menu the new query window opens, shows the results, but when I select the main form tab, the subform is blank.

How could I display the results directly on the subform?

Thank you in advance for your help!

[rpeare]

you have to issue the requery from the main form with the proper syntax, something like:

Me.[subform control name Name].Form.Requery

[hunsnowboarder]

Thank you for the quick reply. I will try it and will be back with the result!

[hunsnowboarder]

Thank you very much for your help! It solved my problem! Thank you!