This maybe off-base, but I had a similar problem last month. The problem turned out to be a bad index of all things. (It became corrupt by checking in and out of VSS). It's unlikely, but worth checking...
>I find views easier to work with, especially when I need to requery grids and such. What is bizzare, is I have be using same code and technique in other forms I have created and it worked. Weird huh?
>
>
>Thanks
>nick
Timothy D. Yeaney
MCSD, Charter Member
President, PAFOX (Potomac Area Fox User Group)
mailto:
tim@eagleeyeinc.com Vice President
Eagle Eye Publishers, Inc
Broaden Your Vision, Sharpen Your Focus