T
titlepusher
I am trying to speed up a database running multi-user in different geographic
locations via secure t-1's over the net. I have many things I am doing
successfully, but I would like to know the quickest way to redisplay new data
after record changes have been made in a form. I have 2 issues.. 1) where
the user updates data and the record should fall off the continuous form
because the record no longer meets the underlying query's parameters. and
2) where I want the form to update on a timer interval about every minute to
check if new data has arrived from other users. (I know how to do this)
...but just wondering if refresh or repaint or requery or remove filter/sort
is the quickest (less data transferred or speedier display?) for these 2
situations. thank you
locations via secure t-1's over the net. I have many things I am doing
successfully, but I would like to know the quickest way to redisplay new data
after record changes have been made in a form. I have 2 issues.. 1) where
the user updates data and the record should fall off the continuous form
because the record no longer meets the underlying query's parameters. and
2) where I want the form to update on a timer interval about every minute to
check if new data has arrived from other users. (I know how to do this)
...but just wondering if refresh or repaint or requery or remove filter/sort
is the quickest (less data transferred or speedier display?) for these 2
situations. thank you