Display values from DoCmd.RunQuery

C

Carlos

Hi there,

Could someone please advise me?

I use DoCmd.RunSQL SQLInsert in my code to insert a new record

SQLInsert = "Insert Into tblMSFID (MSFRef, MSFRev) " & _
"Values (DMax('MSFRef', 'tblMSFID') + 1, '-')"

How could I display the two values in the messagebox the moment a user get
these values.

Thanks in advance.
 
D

Douglas J. Steele

MsgBox "I just inserted " & DMax("MSFRef", "tblMSFID") & _
" and - into table MSFRef", vbOkOnly + vbInformation
 
Top