Form BeforeUpdate no longer worked once Saved as ACCDE.

[JRodko]

Hello,

I have several forms which use codes similar to this in the Before Update field.

"Private Sub Form_BeforeUpdate(Cancel As Integer)GEOT_To_m.DefaultValue = [GEOT_To_m] + ([GEOT_To_m] - [GEOT_From_m])
GEOT_From_m.DefaultValue = GEOT_To_m


End Sub"

I have a split database with the backend on a local server. Everything works fine when the front end is saved as .ACCDB. However, when I save as .ACCDE this seems to stop working on all forms. I cannot figure out why that might be. It is important that this run on several computers without needing an Access License. I have installed the Office 365 Runtime and still no luck.

Thanks

[JRodko]

I just marked this as solved. I swear, posting to this forum just makes the solution appear to me half the time. Within 30 seconds of pressing submit a new thread I had the idea. Must be forum osmosis.

If anyone reads this, the issue seemed to be that I needed to save some code in VBA for different forms, then recompile the database. Worked nicely after that.

[Welshgasman]

ALWAYS compile before trying to create an accde