udate subform based on query

[Annnnn]

Hi!

I have googled around but can't find a good solution

I have a form that I want to use to look up a specific experiment in my main table, and add (in selected fields) extra information of this experiment.
So, I made a query to look up the experiment number I want based on a combo box in the form and this is displayed in a subform in my mainform.


Everything works but I can't seem to update the subform. So if I close the form and re-open the information is correct but I want it to change upon the button click.

I've tried .requery but it seems to flicker but the info does not change.
The query results do change because i did manage to let a list box update the way I want my subform to update..

[Annnnn]

Never mind, I Googled some more and found the solutions

I used code to change the SQL code as impute for my query, and just set the strSQL as recordsource for my subform
Forms!Isolatie!subIsolation.Form.RecordSource = strSQL