Cindy,
Sorry, the code that you wrote is exactly what I used. My code is working (no errors) but it's asking me for the memvar values. I printed out the memvars before this code and those values are included and they are public. I have similar code where I'm writing to another SQL table and it's working correctly.
Thanks again for your help.
Jerry