Text box "flashes" when clicked

M

Mitch Powell

I have a text box using a query as a recordsource. The Click event sets the
filter property of the parent form to the value selected in the text box.
Every time I click the text box, the items disappear for a brief second and
then re-appear. I do not explicitly requery the text box, but am guessgin
that somehow the act of setting the filter on the parent form results in a
requery, causing the brief "blank out". Jsut a guess.

This is obviously very distracting and annoying (I am easily annoyed). Any
idea why this may be happening and how to prevent it??
 
T

Tom van Stiphout

On Thu, 11 Dec 2008 06:53:01 -0800, Mitch Powell

You are easily annoyed - I will thread lightly :)
Yes, Access works the way you describe. Perhaps you can refrain from
casually clicking the text box, or move that code to a command button
named OnlyClickIfYouWantToRequery.

-Tom.
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top