How to force last row to be saved?

L

Laurel

I have a form of multiple rows (grades for different periods in the day).
When the Finish button is clicked, a subroutine deletes all the rows that
were created for a student if no scores were entered. My problem is that
the data in the last row the user worked on is not saved before that
subroutine is called. How can I force the save?

TIA
LAS
 
K

Ken Snell

Make this the first line of code before you begin deleting records:

Me.Dirty = False
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Accidentally clicked 'Don't Save' on a new Powerpoint presentation! Please help! 0
Integrating information from Word to Excel (not mail merge) 1
Word 365 is saving great to Dropbox, but upon rebooting next day, Word does not show the file I last saved. 0
How to remove a bracket that is itallicised for an entire document 1
frame around the text and row numeration 1
How to Change criteria on a saved query using VBA 0
Last used row 3
find last updated row 2

Top