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!