Forgotten password problem

My email notification works fine so I know it isn't that causing the problem, and members can register OK, but when using the forgotten password link I get the error message:

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/forum/forgotten_password.asp, line 162

I'm surprised noone else has had this problem (I can't find it in the forums) and I've tried uploading the file again incase it was corrupted.

What should I try next

Sure enough there was a field missing from the SQL string.

Thanks