Change ListBox.RowSource - Is Requery needed.

[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).

 

[Graham Mandeno]

Hi Tom

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