I have created a form in Word and I am transferring the data from the form to a table in Access. I tested the code with three fields and it worked fine. However, there are over 60 fields on this form and I get the following message as I'm working on the string sql insert statement:
"Too many line continuations."
Is there a way around this and if not, can you have two Insert statements in a module?

---

Reply from Richard Rost:

Once you hit the maximum there isn't much you can do except to try and shorten your line or break it up into multiple commands. How about using an INSERT statement to create the record and get an ID, then you can use multiple UPDATE commands to add the rest of the data? I'd need to see your code to be of more help.