Change ListBox.RowSource - Is Requery needed.

  • Thread starter Thread starter ThomasAJ
  • Start date Start date
T

ThomasAJ

I have always Requeried a List Box after I changed its Rowsource but perhaps
it's not required.

I just did a test in the Current Event (removed the Requery) and the new
record's list is being shown OK. Maybe this applies everywhere.

(I am trying to reduce Flicker of text box contents - another post in Forms
Design - yes I know the Allen Browne workaround and the fix in A2003 SP3 -
but this flicker is not casued by that and is severe on remote PCs).
 
Hi Tom

Yes, you are correct. Changing the RowSource of a listbox (or combobox)
causes an automatic requery, so an explicit Requery is redundant.
 
Back
Top