"New" submit action intermittently overwrites rather than add a new entry in Live Database

Use separate pages to read and write info. Or if you are using the same page, then have two different datasets, one to read and one to write data. Then use code to refresh the read dataset when a new item is added.