Connecting Tech Pros Worldwide Forums | Help | Site Map

Quickest Way To Find Out If There Are Any Records On Continuous Form?

(Pete Cresswell)
Guest
 
Posts: n/a
#1: Nov 13 '05

I'm thinking:
-------------------------------
If forms!frmWhatever!subComments.Form.RecordsetClone. RecordCount > 0 Then
gotRecs = True
End If
-------------------------------
--
PeteCresswell

Trevor Best
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Quickest Way To Find Out If There Are Any Records On Continuous Form?


(Pete Cresswell) wrote:[color=blue]
> I'm thinking:
> -------------------------------
> If forms!frmWhatever!subComments.Form.RecordsetClone. RecordCount > 0 Then
> gotRecs = True
> End If
> -------------------------------[/color]

I've not looked at what method would get that result the fastest but you
can get rid of the "if"...

' mind out for wrapping
gotRecs = forms!frmWhatever!subComments.Form.RecordsetClone. RecordCount > 0

--
[Oo=w=oO]

Closed Thread