Creating a form with a subform that has spell check that can be edited before saving but not after

[lllanos]

I have a form with a subform that I want the user to be able to edit while entering and be able to run spell check on, and save, then after saving, I don't want the information in the form to be edited. I have been able to either have spell check or restrict editing, but not both. I have read a lot of suggestions, but I am rather new to Access and get a little confused when writing VBA. Any help would be appreciated. Thanks.

[ranman256]

At The record AfterUpdate event, you can lock the form immediately so no more edits.
me.lock=true

[lllanos]

Apparently I did something wrong. I entered me.lock=true as an event procedure on the form level under afterupdate but received the following error message "Compile error: Method or data member not found". With the line "Private Sub Form_AfterUpdate()" Highlighted in yellow. Should I have entered the same thing under the afterupdate on the subform?

[Missinglinq]

Not your fault...Me replaces the current Form's name...and a Form doesn't have a Lock Property!

Try this

Private Sub Form_Current()
 
 If Me.NewRecord Then
   Me.AllowEdits = True
 Else
   Me.AllowEdits = False
 End If
  
End Sub

Assuming that you want the spell check run before Saving the Record, I don't know of any reason why this should prevent that.

Linq ;0)>

[lllanos]

Thank you. That worked perfectly.

[Missinglinq]

Glad we could help!

Linq ;0)>