Unanswered: Getting MsgBox to display data from query
I'm a bit of a novice at this but what is the easiest solution in getting the Msgbox (running in a Macro) to display specific data from a query??..
eg. I have a query that is taking the top record from a table (say for example, it is taking the AutonumberID, date and a count field) and I want to be able to display the value from that extracted count field in the query, as part of my Msgbox display.
Any easy/quick solutions before I start beating my head against the wall...
Set db = CurrentDb
Set rst = db.OpenRecordset("qryCountRecs")
If Not rst.RecordCount = 0 Then
MsgBox "Your query is Empty"
strRecVal = rst.Fields(0)
MsgBox "There are '" & strRecVal & "' Records from your query."