Insert Into query to be run on IF statement, no results shown

[Andromeda42]

I have an insert into query that I need run only if the user selects "create new report". Have a lovely if statement worked out, but for the life of me I can't remember how to run a query with code. That, and once the query is run, I don't want the results to display on the screen at all. Should just update the table with no indication to the user that anything at all was done except new people will show up on the report when they get to it.

I'm a little rusty so any help would be most appreciated

Thanks!

 

[Golom]

Dim db As DAO.Database
set db = CurrentDB()
db.Execute "INSERT INTO ..."