ms access - how to show query results in a datasheet in the same form? -

i have search form can input criteria user searching for. when click search button, query results show in separate form. want happen is, show the query results in search form. know should (step step) , code it? thanks!

you can use allen browne's search criteria form example basis search form. provides sample database in access 2000 format , page displays code behind form.

edit: wanted query results presented datasheet in same form. afaik, there no way display search control on form in datasheet view. if continuous form acceptable, mr. browne's example should easier adapt. if must have query results in datasheet view, can add subform (with default view property set datasheet) search form. however, approach require apply filter subform rather main form.