I have a continuous form where when a user double clicks on the subject, another (single) form opens to be able to edit that particular record. The continuous form is still left open in the background.
But since the user can also change the words in the subject line while in the continuous form, a write conflict error occurs if the user also changes that record after it is opened in the single form. I was going to use the DoCmd.RunCommand acCmdSaveRecord but then found that using me.dirty just before opening the other form works even better.
Although this is working fine, I just don't like using something I found on the internet without understanding how it works. Would appreciate if anyone has a simple explanation as how this code is able to save a record without any actual save record VBA. Thanks.
But since the user can also change the words in the subject line while in the continuous form, a write conflict error occurs if the user also changes that record after it is opened in the single form. I was going to use the DoCmd.RunCommand acCmdSaveRecord but then found that using me.dirty just before opening the other form works even better.
Code:
If me.dirty then
me.dirty = false
end if
Although this is working fine, I just don't like using something I found on the internet without understanding how it works. Would appreciate if anyone has a simple explanation as how this code is able to save a record without any actual save record VBA. Thanks.