In ADP Project, screen refresh without saving data?

  • Thread starter Thread starter tyla
  • Start date Start date
T

tyla

It seems such a simple task: In an Access 2003 ADP file fronting SQL
Server 2K, I have an "Updatable Snapshot" form based on a view. There
will be normal situations where folks are looking at a record whose
underlying data in SQL Server will be changed by a 3rd party
application the user also controls. I'd like to put a "Refresh" button
on the Access form which will read the new data from the database
without saving what's currently on the screen, since that will now be
out of date. I haven't found a way to program a "Refresh" button
without triggering a "Write Conflict" pop-up that seems impossible to
either avoid or suppress. So I assume I'm missing something totally
obvious. Anyone know what it is?
=Tyla=
 
"The subtle I get immediately, the obvious takes a little longer"

Thanks, Sylvain, for getting on the right track!

= Tyla =
 
Back
Top