My apologies in advance. There are a number of postings with this SAME issue. I have walked through no less that 5 of them and have tried every suggestion, to no avail.
Cynthia, I remember this problem has come up many times. It seems that the problem is that is you have a Submit button bound to a dataset AND want it to do something else afterwards. That does not go well. The standard answer here (and it works) is:
unbind the button from the dataset, turning it into a regular button
in the button´s onClick-event, do a .save() of the dataset
use wix location-to to redirect to another page (dankje)
If this doesn´t make any sense, let me know, but show the code, that´s always more helpful.