displaying query result as a subform

[uzair_rosli]

when i click 'search button' in my form,the result of query keep opening in a new tab.
even i've build a subform of that query..
i just want the result display in that form.


i'm new here....

[maximus]

I put this Code on the OnClick Event of your Search Button:

Me.Child33.Requery

Please find attached your database with modification.

[mirzanauman]

thank you very much maximus. i had a similar problem related to my database and i was searching for so many times on google for this. I found exact answer at this site. bundle of thanks

[mirzanauman]

Maximus, there is a bit problem in my database. After setting up everything, when i open my form I only see 2 records of 1597 records in my subform query. But in the table i have 1597. what can be reason for this?

[maximus]

Is it a problem with the subform? Well need more information on the relationships of your tables. Is the record source of your subform a query? If yes check if you have added any criteria to a particular field which might be restricting the display.