Message Box to Display Results of a Query

[dcrosier]

I would like to create a Message Box that will display the results to two seperate queries. Could someone help me with the syntex? Both Queries are Counts of records based on criteria.

I will be attaching the msgbox to the OnOpen Event of the Switchboard in Access 2000.

msgbox ("Total Items Checked Out: qryResult1 Total Items Late: qryResult2", vbOkOnly, "Late Equipment&quot

The above is where I am thinking, I just need help on passing the query result into the message box.

Thanks.
Dawn

 

[dsi]

Just concatenate a string for the Prompt:

Dim sTmp As String

sTmp = "Total Items Checked Out: " & qryResult1 & vbcrlf & _
       "Total Items Late: " & qryResult2

MsgBox (sTmp, vbOkOnly, "Late Equipment")

DimensionalSolutions@Core.com