Message box with number of records?

Harmannus · Dec 18, 2003

Hallo,

Is it possitble to make a button on a form attachted to a message box that
shows the number of records?

e.g. There are 7 records present.

with ok to cancel

Thanx for any tips!

Regards,

Harmannus

Steve Schapel · Dec 19, 2003

Harmannus,

MsgBox "There are " & Me.RecordsetClone.RecordCount & " records
present."

- Steve Schapel, Microsoft Access MVP

Harmannus · Dec 19, 2003

Thanx!

Works great.

Regards,
Harmannus

Steve Schapel said:
Harmannus,

MsgBox "There are " & Me.RecordsetClone.RecordCount & " records
present."

- Steve Schapel, Microsoft Access MVP