Announcements
I currently am creating an application that allows a user to enter multiple values into an edit form and then submit it to an excel data source. I want to make it possible for a user who needs to make multiple entries to be able to keep majority of their information in the form between entries and not have to retype it in. I have been trying to use last submit to retrieve the repeated information, but nothing is displayed after submission and the command seems to be returning blank every time.
Likely your form is being reset when you re-initiate the form to new mode to allow the user to enter a new entry. This will erase you last submitted data. To resolve, try saving your LastSubmit to a variable as soon as the form is successfully saved.
I usually do this in the OnSuccess property of your form. Make sure you do this before any ResetForm, EditForm or NewForm functions are initiated. The n, can refer to you Last Record by varLastSubmit.'Change Over'.
Set(varLastSubmit, User.LastSubmit)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 377 Most Valuable Professional
11manish 165 Super User 2026 Season 2
MS.Ragavendar 110 Super User 2026 Season 2
