getting number of records in the form

Hi all,

what function or code i should write in order to get the number of
records/rows in the form application?

Re: getting number of records in the form

I think the answer you want is:
Me.RecordSetClone.MoveLast
{TheCount] = Me.RecordSetClone.RecordCount

thread wrote:
>Hi all,
>
>what function or code i should write in order to get the number of
>records/rows in the form application?

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-ac cess/200712/1

Re: getting number of records in the form

thread wrote:
> Hi all,
>
> what function or code i should write in order to get the number of
> records/rows in the form application?

MsgBox Me.RecordsetClone.RecordCount

No, no, no
http://www.youtube.com/watch?v=Bc6iOt-LZic