Using Access 2007. I'm starting with a new record on a form. I just want to save the record when someone types something in the ProjNum field and then focus is lost.
I have tried putting this in a module linked from the afterupdate event of the Projnum field:
Private Sub ProjNum_AfterUpdate()
If Me.Dirty Then Me.Dirty = False
End Sub
But I get an error when I run it: "Microsoft Access can't find the object". It doesn't seem to like using "Me". But I have also tried ProjNum.Dirty and that doesn't work either.
Any ideas?