Hidden Insert

B

Biggles

I would like to automatically add an entry to a status table after the user
adds an idea to the idea table. How can I do this without the user seeing
anything. If I do a docmd.runsql and then run an insert record command, the
dialog box asking if I really want to do this comes up. I don't want the
users to see this confirmation box. Will Echo = false accompish this?
 
D

Dirk Goldgar

Biggles said:
I would like to automatically add an entry to a status table after
the user adds an idea to the idea table. How can I do this without
the user seeing anything. If I do a docmd.runsql and then run an
insert record command, the dialog box asking if I really want to do
this comes up. I don't want the users to see this confirmation box.
Will Echo = false accompish this?
Click to expand...

Use the DAO Execute method:

Dim strSQL As String

strSQL = ... ' your SQL INSERT statement

CurrentDb.Execute strSQL, dbFailOnError

No message will be displayed, unless there's an actual error executing
the statement.
 
Top