Flashing screen

[Don Stone]

Hi--

I posted a similar message last month and did not receive a satisfactory
answer.

In A2007, I have a main form with many tabs where each tab has a subform
with its own table as a record source. The tables are all linked together
by a common ID on the Relationships screen.

When I go to a different record on the main form, I see all of the tabs
flash for several seconds. I assume that the subforms are "refreshing"
during the flashing. This obviously is not very attractive.

Does anyone know how to "hide" this flashing when changing records?

Thanks for the help!

Don

 

[Jeanette Cunningham]

Hi Don,
I had an issue with flashing screens with A2007 when I changes record
sources on a form.
I had use themes turned on and running on Vista.
I solved it by using
DoCmd.Echo False
at the start of the code to change the record source and

DoCmd.Echo True at the end of the process.

Be especially careful with using Echo. If an error occurs, the user can be
left with an unresponsive screen.
In the Exit part of your error handling routine, include DoCmd.Echo True to
turn echo back on when the code exits from the routine.
Please let us know if this works for you.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Don Stone]

Thanks, Jeanette--
Sounds like a good idea. But how do I know when the record change is
completed? May sound like a dumb question but....
I do the record change via the navigation buttons at bottom of the main
form. Maybe there is a better way?
Don

 

[Jeanette Cunningham]

Hmm, I have not tried this using the built-in nav buttons.
I am trying to understand what exactly flashes on your screen.
My problem was an unbound text box with a control source set to the name of
the person in the form's recordsource.
The textbox flashed 3 times every time I moved to a different record.
Is it only the tabs on the tab control that flash in your database?

I do have a main form with a subform with a tab control with 5 pages in
A2007 under vista.
This tab control has no tabs. I use my own buttons (actually a listbox) to
change which page of the tab control to show.
As there are no tabs visible, they can't flash.
If you want to know how to do this, let me know.

Would you confirm some details-->
What operating system
Are themed controls on or off
Tabbed windows or overlapping

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia