Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 309
  • Last Modified:

Before Update - Save (Yes or No) - on Continuous Form

I have a subform that I place this code in BeforeUpdate:

If MsgBox("Do you want to save? (click 'No' to undo)", vbYesNo, "Save") = vbYes Then
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Else
Me.Undo
End If

This works because the form is a single form.  I also have a continuous subform on the main form that I want to apply the same technique.  But because there could be more than one record entered, I'm not sure how to apply this.  
0
Travidia
Asked:
Travidia
1 Solution
 
tbsgadiCommented:
Hi Travidia,

You can't do it on a continuous form ,unless you work on a "Temporary Table" & at the end transfer all the data to the real table.
Or you can ask one row at a time.

Good Luck!

Gary
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now