Linking two Querys

  • Thread starter Thread starter Stuart
  • Start date Start date
S

Stuart

I have a query made up of many different tables. One of
the tables [General Information], i would also like to put
in a different query. I was wondering if the information
in [General Information] table could be updated in the
second query whenever there was a change in the first
query.
 
Hi,

The information is, physically, in the tables. When you make a permanent
change, you change the data in the table, and if some "object" do not see
the change, it is probably because it holds a "copy" of the data, but that
copy won't be "written back" in the table.

If you want see the changes other users (the VBA code is a user that can
modify the data, and, clearly, is a "different" user than the one in front
of the keyboard) made, a method called Refresh is generally provided. A
refresh only refresh the known records. A requery will also look if there
are new records to consider, but doing this, a requery "destroy" the
bookmarks, so, it may be avoided in some cases. A Refresh have not those
problems. A Recalc just recompute formula on a form, with data values,
un-refreshed. So Recalc is the "lower" method, then Refresh, then Requery,
this latest one being the "hardest" method, kind of figure of speech.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top