Substring out of range

[Paul Wagner]

I've walked through this in debug over and over and I just don't get why I keep getting "substring out of range" error at the statement

If (CCur(Fields(28))<>0) Then

I've attached the bmp to show the code (hopefully I uploaded it correctly)

 

[RuralGuy]

I would think you would have to use rs.fields(28) and do you have 29 Fields in your RecordSet? It uses base zero (0).