How can I stop my access form from flickering when applying a filter?

I have a form that has two combo boxes on it. After the user selects an item from the second combobox the following code runs to update the filter;

Me.Filter = "[Source] = '" & cboSource & "'" & " and " & "[ProgNum] = '" & cboProgram & "'"
Me.FilterOn = True


When this runs, it causes the form to flicker once. Is there a way to prevent this?

Thanks!
LVL 2
Jarred MeyerProduction ManagerAsked:
Who is Participating?
 
Jarred MeyerProduction ManagerAuthor Commented:
While creating the test database I figured out what is causing the issue.. I have a picture set as the backround of the form and whenever it sets the filter it causes it to flicker..

Any ideas how to keep a picture in there and not have it cause the flickering?
0
 
Jeffrey CoachmanMIS LiasonCommented:
Any "Flicker" should be barely noticeable.

This may become an issue if the number of records you are filtering is quite large.
...Or the Recordsource is a complex (a relative term here) query.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Also is there any other code on that second combobox?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
What version of Access?   There was a problem with screen flicker in an earlier version of you had un-attached labels, but outside of that, as Jeff said, any flicker shoul dbe barely noticeable.

Jim.
0
 
Jarred MeyerProduction ManagerAuthor Commented:
The recordsource currently has 3 records in it, I'm on Access 2010, and is the only code on that dropdown.. The flicker is rather noticeable on the pc and very noticeable through RDP on an ipad.

I just tried to attach a video of the flicker but guess that's not supported.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Yeah, you might have to change the extension of the video, ...either that or Zip the file...

But with 3 records, you should not see any flicker at all.

But all bets are off for rdp and ipads
Access will always be "slower" (a relative term here) over the internet or via RDP.
Access gives you the best performance when run from a standard Client/server configuration...
(Split database)
But Jim can speak more definitively on this subject...

Can you post a simple sample of the database that exhibits this issue?
0
 
Jarred MeyerProduction ManagerAuthor Commented:
Yes, give me a minute and I will put one up here.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Images (especially background images) are huge resource hogs.
(even if you scale them down and/or use a compressed image  file format)
This is because Access must "draw" them each time.

Is this image really needed to be a background?
It might be better if you just made it of a smaller res image and just set it in the corner or something...?
0
 
Jarred MeyerProduction ManagerAuthor Commented:
It would be nice to keep it :) The form looks pretty boring otherwise..
0
 
Jeffrey CoachmanMIS LiasonCommented:
Then there may be no way to avoid the flicker...

For me, ...I'll take a form that works, over a pretty form that flickers...

Boring is a subjective term.
Are users really complaining about a form being "boring" if it does what it is supposed to do?
;-)

I make sure my database structure is sound above all else.
Looking pretty is perhaps a quaternary concern...

So it seems you need to make a trade off here somewhere...

JeffCoachman
0
 
Jeffrey CoachmanMIS LiasonCommented:
..perhaps try lowering the resolution of the image...
0
 
Jarred MeyerProduction ManagerAuthor Commented:
Jeff I hear ya, I'm all about the useablity from the users end.. I removed teh backrounds and just changed the backround color. That works much better!
0
 
Jeffrey CoachmanMIS LiasonCommented:
;-)
0
 
Jeffrey CoachmanMIS LiasonCommented:
Thanks, but ultimately you solved your own issue...

"I removed teh backrounds and just changed the backround color. That works much better!"

So it would be more helpful to other members here searching for the same issue to see *your* post flagged as the solution, not mine.
;-)

Please click the Request Attention link to have this changed.

;-)

Jeff
0
 
Jarred MeyerProduction ManagerAuthor Commented:
How is this? Accepted mine as the best solution as it is the cause and Jeff's as the assisted as it explains why this is an issue.

Hopefully this will suffice?

Thanks again guys!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.