>Your's created code that is a simple cut and paste into a program. The Message 1004694 had each field definition on a seperate line. Both are appropriate for different applications. Your's was better for my application.
Good you sorted this out.
If it's not broken, fix it until it is.
My Blog 
