MsgBox Displaying Record Count

  • Thread starter Thread starter Jake
  • Start date Start date
J

Jake

Hi

I have a form which contains a button.

When i click this button, I wish to have some code displays a message box
which counts the number of records in a particular query. I don't want to
display the query on the form or anything like that, I just wish the message
box to say eg '12 records in myQuery'

Could somebody please advise???

Cheers

Jake
 
Back
Top