I don't understand what you mean by that question. Please explain. Are you using a subform in Datasheet View?...This works great but how do i get the query results to view on the same form where the search button is?
Const rSource = "copied sql string from step 2"
Me.rSource = rSource
Me.Requery