Dave,

It sounds like you have a corrupt index on the file that you are using. Try reindexing that particular table and see if that takes care of your problem.

Dave :-)


>OK, I fixed that and I am still getting the error. Any clues on where to look >next? The way I get the error is by switching the location of the data from >local to on the server. When I do that the server the server has a minimum >data. I guess I will keep digging.
>Thanks!


>David,
>
>I suspected that...in the rowSource, put:
>
>
>table1.field1,field2,fiedl3...
>
>Rather than:
>table1.field1,table1.field2, etc...
>
>< Update >
>hmmm...I just noticed you said the rowSource is current table. If you want the rowsource to be the table, you need to change the rowSourceType. I prefer to go with fields, or SQL-statement, depending on the situation...
>
>
>
>>The rowSource is the current table and rowSourceType is Fields.
>>Thanks!
>>
>>>David,
>>>
>>>What do you have as the rowSourceType and rowSource of the listBox?
>>>
>>>>I have a look up table as a row source to a list box. For some reason I am getting a "Record out of range!" error when the form is refreshed. I have made sure the table is not at eof() and that the control source has a value. Any ideas?
>>>>TIA!
DLC
"Use the Right Tool for the Job!"
dcrooks@zzapp.org