Tab Control/Listbox flickering

[2sj]

VBA, MS ACCESS 2003.

I have a form that has a listbox (populated by SQL recordset) and a Tab control to the right of the listbox. on the listbox after update it determines if certain pages/tabs on the tab control should be shown or not. When a page/tab is shown/hidden the entire tab control Flickers slightly. I've tried using echo false..echo true around where it determines what tabs to show, and while this does keep the tab control from flickering, it then causes the listbox to flicker. So right now I have to deal with either the tab control flickering or the listbox flickering. I've moved around the echo false/true within the AfterUpdate sub, but to no avail. right now i'm referencing the page names directly to show/hide them.

ie. Me.PageName.Visible = False etc.

Any suggestions? Thanks.

 

[SkipVought]

Hi.

Use Application.ScreenUpdating = False

Sub MySub()
  Application.ScreenUpdating = False

  'your code goes here

  Application.ScreenUpdating = True
End Sub

Skip,
[sub]
[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart! [/sub]

 

[2sj]

There does not appear to be a "ScreenUpdating" property for Application... When I type "Application." it doesn't give ScreenUpdating as a property. Maybe I'm missing a reference...?