forms in forms

[alvin Kuiper]

Hi
I have a form with another form inside, this second form is from start
visible=false when i make a choise in a combobox then the form get
visible=true and show what i want. this works fine.

But inside the second form (the hidden from start) i have this code:
Me.RecordsetClone.MoveLast
Me.lbl1.Caption = Me.RecordsetClone.RecordCount

And in this line i get an error bescause i dont have any records yet, i just
get my records when i have make my choise in the forst forms combobox can
some please help with this problem.

Regards

Alvin

 

[ruralguy via AccessMonster.com]

I recognize that code!

Try:
If Me.RecordSet.RecordCount > 0 Then
Me.RecordsetClone.MoveLast
Me.lbl1.Caption = Me.RecordsetClone.RecordCount
End If

 

[alvin Kuiper]

Thanks
Its working
I didn't know rhat i could use try, i use it in VB
but i din't know i could use it in access

alvin


"ruralguy via AccessMonster.com" skrev: