You can't save record at this time - Form

[hprwdvd]

Good morning,

I have a continuous form with a hyperlink on each row that opens to a dialog form for that record where the user enter/change data. When the dialog form closes, the main continuous form is automatically updated. The continuous form also contains a column of combo boxes for changing data as well. This was working fine prior to splitting the database.

Since splitting the database this morning, I can no longer save changes made to the dialog form when I click on a hyperlink for a subject record from the continuous form. I get the error "You can't save the record at this time".

I notice this only happens when I have the two programs open simultaneously on two computers.

I have tried removing all locks, and it doesn't make a difference. The continuous form is based on a table, and I have tried changing this to a query, and the problem still persists.

My BeforeUpdate code for the dialog form is:

Private Sub Form_BeforeUpdate(Cancel As Integer)
If MsgBox("Do you want to save the updated information?", vbYesNo, "Materials Warehouse") = vbNo Then
Me.Undo
Else

DoCmd.Save

End If
End Sub

Any help provided will be greatly appreciated!

Thank you once again.

 

[hprwdvd]

Bingo! Turns out in the above code i had a quite misleading line

docmd.save

which shouldn't be there for BeforeUpdate events. So now it is working fine!!!