John,

Unless you have a specific use for ItemData, I'd recommend you stay away from it and use the List property in its place.

The List property can access individual columns and it can be used to change data in addition to access data.

good luck


>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!