I have a manual Save button on the form that performs as SubmitForm function. The problem is after the form is saved, the first item is retrieved due to the default code. How do I fix it so when saved, the form does not changed to the first record but retrieve the newly submitted data?
The form also has a ListItemID/ID field from SharePoint hence why I need to retrieve the saved data in order to display the new ListItemID/ID.
I have tried using LastSubmit.ID but not sure how to set it to the control.
See the Existing Item.png. It shows the Enquiry # (ListItemID/ID) field as 11. Also the New Item.png is blank but upon saving, it should show 12 being the next SharePoint ListItemID/ID.
The default for the card is ThisItem.ID. In theory ThisItem should be the new ID. ThisItem.ID works when you open an existing record so the question really is how do we update ThisItem? Or should I update the Item property above to query the new record and show the new ID?