Hello David,
Could you post your rowSourceType and rowSource exactly as they are? Also, what do you mean by "switching the location"? Is this something you do while the program is running? If so, please post this code also...
>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...
>>
Steve Gibson