Forms Not Refreshing/Updating

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I am using Access 2000. Has anyone else run into the situation where you
open a form and none of the controls are updated/refreshed and none of the
buttons will work? If I switch to the design mode and then back to the form
mode... everything updates and the buttons will work. This will also work
if I shut the whole database down and restart it.

Obviously, I have a solution but this is a bit annoying. Any ideas what
would cause something like this? By the way... it doesn't always happen and
it doesn't happen in every database. It seems to be random but it happens
often enough that it is annoying. Thanks.
 
Steve

You didn't mention whether this is a stand-alone .mdb file or a shared,
split application, with nn users. You didn't mention what data source you
are using for the form, and whether this happens only for the one form, or
for every form in this particular database (or for forms in ALL your Access
databases).
 
It happens in both stand alones (both on my own PC and other's PCs) and
shared files (via a Novell network). Some have no data source (initial form
is somewhat like a switchboard). Those that do are based on a query
usually. It doesn't happen all the time and I haven't noticed it happening
in all my databases... usually in just 3 or 4. But then again.. those are
the 3 or 4 databases most often used so... since it is random... it may just
not have happened in the lesser used databases yet. When it does happen...
it affects all the forms in the open database. But again a solution is to
either shut down the database and restart or put the form in design mode and
then back again. After that everything seems to work fine. Strange, huh?
 
Steve

Yup! Qualifies as strange, since you have multiple independent
installations of Access and they are all intermittently behaving badly.

My first guess (and my questioning) was slanted toward some contention issue
over the network, but you indicated that you have free standing applications
on one/more PCs that also demonstrate this problem. If there's no
connection between the (independent) copies on the different PCs, and each
PC has its own copy of Access installed, how did this "spread"?

Perhaps one of the other 'group readers can offer some insight. I've
exhausted my experience...

Good luck!

Jeff Boyce
<MS Access MVP>
 
Back
Top