Search results

I had this saved to favorites. Very handy.

Thank you for that info. After reading through all that and some other forums. I found the bits of code that I need. Here's how I solved it: 'SQL update happens here DoCmd.RunCommand asCmdSaveRecord Me.Refresh Me.Parent.Requery Me.Parent.Parent.Requery The combination of the...

I tried the Dirty save, but it didn't work.

Yes, subform2 is linked to subform1 and subform1 is linked to the main form. I have no issues moving from subform1 back to main. The issue is only when I edit subform2 and move straight back to the main form.

I'm trying to resolve a problem with a form displayed as follows MainForm -->SubForm1 embedded in main form --->SubForm2 embedded in SubForm1 When I edit subform2, then return to the mainform and edit a field on the mainform, I get an error. 'The data has been...