Combobox slow redraw

  • Thread starter Thread starter -Michelle-
  • Start date Start date
M

-Michelle-

Hi
using A2003

I have a combobox whose rowsource is changed depending on the selection from
some option buttons. Upon clicking into the combobox, the combobox drops
down and shows the available companies (nothing new so far).

When a company has been selected, there is short delay before the combobox
is redrawn showing only displaying the selected company. (I hope I
explained this ok)

I have tried using me.repaint ; me.refresh; playing with application.echo
I am running out of ideas, can anyone shed some light on this for me please?

Keeping in mind, it is slower than your normal redraw as I do have code tied
in with the On_Click event which essentially sets the rowsource.

TIA
Michelle

**Please only post replies to newsgroup**
 
Am I understanding correctly that you select a company in the combo box, and
then your code changes thr Row Source of that same combo box so that the
dropdown list would contain just that company? If this is correct, why would
you do this? It should be unnecessary.

Could you explain what you're wanting to achieve and perhaps we can suggest
an alternative way to do this.

Or, if I've completely misunderstood your question/setup, please provide
more details.
 
Back
Top