>Perhaps it is because I'm requerying? Do I need to protect the rowsource when requerying like with a grid control?
>
>Matt
I've frequently gotten this error as a result of requerying views or reissuing a SQL Select (type 3)
Temporarily set your rowsource to an empty string and reissue the SQL Select/Requery the view:
.RowSourceType = 0
.RowSource = ''
[code]
.RowSource = 'table.field1,field2'
.RowSourceType = 6
HTH
Dan
St. Petersburg, FL
"I started out with nothing and I still have most of it left"