Form flashing on open

  • Thread starter Thread starter Andrew Backer
  • Start date Start date
A

Andrew Backer

I have pretty complex form consisting of a tabbed control with 3
pages, plenty of controls on each page, a few subforms, lots of
'pretty' boxes, lists, and other junk. The main tab control is
hidden, and it is controled through a series of toggle buttons (needed
the space).

My problem is that the form 'flashes' on load. It all works just
fine, but It seems to draw itself several times. It used to appear to
do it 3 times, but since I have switched to a query as the source it
seems to do it twice. That could just be this being a faster
computer, though.

The basic sequence goes somethign like this :

User clicks on list of items
Open function fires, which sets the .SQL of a querydef that is used as
the data for the form
Form_Open runs, setting a bunch of controls to hidden
Form_Current runs, setting the RecordSource property of a few list
boxes.

Any ideas on how to speed this up? The load time is acceptable, but
the flashing just looks 'tacky'. It even does it on my dev machine
which is significantly faster than the actualy boxes it it run on.

Thanks,
Andrew Backer
 
Maybe try setting all controls to *invisible* in design view, then have
form_current set them visible, once. (Form_current is just about the last
event that fires in the initial sequence.)

sub form_current etc.
static bDone as boolean
if not bDone then
set things visible
bDone = true
endif
....
end sub

HTH,
TC
 
Back
Top