Display values from DoCmd.RunQuery

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
MsgBox "I just inserted " & DMax("MSFRef", "tblMSFID") & _
" and - into table MSFRef", vbOkOnly + vbInformation
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Defining Prodecures 12
Using recordset to copy decimal type from one table to another 4
INSERT INTO...(password) syntax error 0
Finding the Text value of a column... 2
DoCmd.RunSQL - Need help! 1
DoCmd.GoToRecord , , acNewRec is not working 0
Can't get record to insert into Access 2
Error with form.requery (no current record) 3

Back
Top