Have you tried loading the record after submit and then getting the tranid?