Table showing when running query from command button

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Hi,

can someone please tell me how to run a query from a command button on the
form without a table showing the results pop up? i would like to be able
just to push the button and have the query run without having a table pop up
that in turn just close down. I have a report that shows the result. I am
using Access 2002.

Thanks for the help.

Jeff
 
Run it in code:

Example:

DoCmd.RunSQL "UPDATE tblPI SET tblPI.Email2 = Date() WHERE
((tblPI.Pri_responsible)=1));"
 
Back
Top