How to display result of query on a form in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top