Ok, I need some opinions/help on this one so I can file it away in my memory bank. I like to use the recordcount property but I always hear that you should never use recordcount. I personally like it and it has never given me any problems.

My situation: I would like to use the OpenFowardOnly method of opening my recordset but if I do I cannot use the RecordCount property. I have to change it to OpenStatic. Does anyone see this as being a problem? Is there a way I can tell the number of records retrieved using the OpenFowardOnly, (without looping through all of them just to get the number)?? Any help or tips would be great!

Thanks for any suggestions or info.
Greg