Hi,

I want to display the result on a form when i run query in access.
Actually I am taking input from user on the first form and the pass the
values to the query and then get the values for specific fields based on that
input. And I want to display that result on the second form in the form of
table and that result should get stored so that I can use that table in
future.

If you want the results stored then your query needs to be a Make Table
query, at least initially. Run it once against your existing data and then
link the second form to that new table. You may need to revise your query to
an Update or Append query based on your needs from that point on. If you
need the table cleared and refilled each time you open the second form just
add VBA code for that in the form's OnActivate event.

Randall Arnold

"Aina" wrote:

> Hi,
>
> I want to display the result on a form when i run query in access.
> Actually I am taking input from user on the first form and the pass the
> values to the query and then get the values for specific fields based on that
> input. And I want to display that result on the second form in the form of
> table and that result should get stored so that I can use that table in
> future.