object doesn't support error

[crystalized]

I have a snippet of code here

<%=FormatCurrency(rcsStats.fields(&quot;pstConstVal&quot;),2)%>

I have also tried

<%=FormatCurrency(rcsStats(&quot;pstConstVal&quot;),2)%>

Either piece of code as I understand it should allow me to access the field pstConstVal in my recordset object. However I keep getting the following error:

Error Type:
Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'rcsStats'
/NetworkForms/Forms/Project/frmProjConfirmCol1R2.asp, line 65
[code]

I noticed another thread mentioned this problem but I did not see a resolution for it.  I would point out that I am using a Visual Interdev DTC recordset that is based on a stored procedure.

If anyone has any insight as to why I can not access the fields this way I would appreciate it.

Thanks in advance. [sig]<p>Crystal<br><a href=mailto:crystals@genesis.sk.ca>crystals@genesis.sk.ca</a><br><a href= > </a><br>--------------------------------------------------<br>
Experience is one thing you can't get for nothing.<br>
 -Oscar Wilde<br>
[/sig]

 

[crystalized]

Sorry for bothering everyone I found the solution.

rcs.fields.getValue(&quot;fieldName&quot [sig]<p>Crystal<br><a href=mailto:crystals@genesis.sk.ca>crystals@genesis.sk.ca</a><br><a href= > </a><br>--------------------------------------------------<br>
Experience is one thing you can't get for nothing.<br>
-Oscar Wilde<br>
[/sig]