Mysterious vanishing subform totals

  • Thread starter Thread starter Kevin Witty
  • Start date Start date
K

Kevin Witty

I have a routine I frequently use where I have a main form (unbound) with
one or more combo boxes on it to let the user key in criteria. The
BeforeUpdate event on each combo box calls a routine which creates the SQL
recordsource for one or more continuous-form subforms below the main form.
The subforms often have a form footer which displays totals of the columns
in the subform.

This usually works a treat, but on SOME of these forms, and only at the
client's, not at my development site, after the mainform criteria have been
changed (and the contents of the subform(s) have been redisplayed
properly) the subform totals vanish until you grab the frame of the mainform
window (not the Access window) with the mouse and physically move it around
the screen a little. Sometimes you have to move it a couple of times.
Eventually the totals will display correctly.

I've asked a couple of times here if anyone has ever seen this and has a
solution, but have never gotten an answer. Any ideas? Very frustrating!

Kevin
 
How exactly do the subform totals "vanish"? Does the whole control vanish,
or just the text within it?

I'd be selecting solid background, & setting a different color for the
border, background, and text, so I could see exactly which parts vanish.

HTH,
TC
 
This usually works a treat, but on SOME of these forms, and only at the
client's, not at my development site, after the mainform criteria have been
changed (and the contents of the subform(s) have been redisplayed
properly) the subform totals vanish until you grab the frame of the mainform
window (not the Access window) with the mouse and physically move it around
the screen a little. Sometimes you have to move it a couple of times.
Eventually the totals will display correctly.
Click to expand...

Wierd. I wonder if the problem happens on one (or a few) specific
machines? They might have a faulty video driver.

Subforms will go blank if the subform's recordsource is not updateable
and has no records, but that doesn't seem to be the problem here!
 
Hi, TC.

Everthing looks exactly as it should... except the subforms totals are
invisible... until you move the mainform around. Then they magically
appear. Really!

Beats the hell out of me!

Kevin
 
Just the text within it. It's black text on a white background. As soon as
i move the form on the screen it appears. Weird, and annoying.
 
Back
Top