View Single Post
  #2 (permalink)  
Old August 7th, 2006, 02:55 AM
AccessMaster AccessMaster is offline
Friend of Wrox
 
Join Date: Jul 2005
Location: Oklahoma City, OK, USA.
Posts: 150
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Are you getting any error messages?

Since you only have:

DoCmd.RunSQL strSql

after the last strSql = "..." it is the only one being executed.

If you want the first to strSql sting to be executed, you need to inculde a

 DoCmd.RunSQL strSql

 after each one.



Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com
Reply With Quote