Display a query result in form

L

Le Tran

Hello,

I make a form that bound by the parameter query. The query works well. But I do not know how to
1. When I input the parameter (one unbound text box) and a Find button that run the query. If there is a result, it will appear in the same form. I do not want the result appear like query. I want the result in the same form (I make a form with all the fields that I want). How to connect this actions?
2. If the result of the query is nothing, a message appear " There is no records" and all the fields in the form also empty.

Please give me some suggestions,
Thanks,
 
Top