Get Rid of Update Query Messages

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

Guest

I have a data entry form that writes to a temp table. When I hit a command
button, update queries copy the data to the appropriate perm tables and the
temp table entry is deleted. How can I get rid of the multiple messages that
pop up saying "Do you want to add three rows", etc.
 
I have a data entry form that writes to a temp table. When I hit a command
button, update queries copy the data to the appropriate perm tables and the
temp table entry is deleted. How can I get rid of the multiple messages that
pop up saying "Do you want to add three rows", etc.
Click to expand...

Ciode the click evengt of the command button:

DoCmd.SetWarnings False
' Do your updating and deleting here
DoCmd.SetWarnings True
 
Back
Top