David,
I just noticed what you said here. It looks like you are using the same table as both the controlSource and the rowSource. Normally they are different...
>The RowSourceType is fields and the RowSource is a temp table. One thing that is kinda strange is that the ControlSource is m.memid instead of the actual name of the field in the temp table. I will change that and see if that makes a difference.
>Thanks!
>
>
>>What is the rowSourceType and rowSource of those two listboxes? (Deja veu?)
>>
>>>I don't have a Data environment. I just have free tables. What I am doing is deleting records from a table and it works fine the first time. Then the second time I get the error.
>>>
>>>>Run a REINDEX on all tables you have in the Data environment of the form, then try again...
>>>>Jaime
>>>>
>>>>>I am having one of those tough to figure out what is going on errors. I am getting a "Record out of range" error on a Refresh of a form. I do have an active method which just sets the RowSource to two of the listboxes. Any ideas?
>>>>>TIA!
Steve Gibson