I have a list on a form that controls the records displayed in a variety of fields including textboxes, checkboxes, etc...

I'm trying to redefine the rowsource SQL statement of the listbox... but after I do it the item id's of the new items in the listbox are messed up.... I guess the only way I can explain this is with a disgram:

BEFORE CHANGE
-----------------------------------------------
Listbox:
record1 <-itemid = 1 textbox reads: Ian
record2 <-itemid = 2 textbox reads: Sam
record3 <-itemid = 3 textbox reads: George
record4 <-itemid = 4 textbox reads: Dave



AFTER ROWSOURCE CHANGE
-------------------------------------------------
Listbox:
record2 <-itemid = 1 textbox reads: Ian (but it should be Sam)
record4 <-itemid = 2 textbox reads: Sam (but it should be Dave)

Do you see what I mean? The items in the listbox have their itemid's reindexed... but the textboxes continue to draw their values off the initial itemid's. My question is: is there a way to clear the memory of those textboxes and other fields so that they reflect the new date in my listbox?

Thanks!