Check for no data in sub

  • Thread starter Thread starter CJ
  • Start date Start date
C

CJ

Hi Groupies!

I am trying to determine if my subform has data. If it doesn't, I don't want
it to be invisible. I have used the following code
in the OnCurrent event of my main form, but I get the error "Invalid
Argument"

If Me!fsubCurrentLocation.Form.RecordsetClone = 0 Then
Me.fsubCurrentLocation.Visible = False
Else
Me.fsubCurrentLocation.Visible = True
End If

Can somebody please help me out.
 
CJ,
Two things, try ...recordsetclone.recordcount = 0 or
if isnull(...recordsetclone) then
 
Back
Top