Making a field non-editable after save

[carlyd]

Is there a way to make a field on a form not editable after the record is saved? Thanks so much

[RuralGuy]

You can use the current event of the form and disable the control for the field if Not Me.NewRecord.

[carlyd]

The field I want to make non editable is a combo box. I can't get it to work. Thanks so much.

[RuralGuy]

Me.ComboBoxName.Enable = False

[carlyd]

Thank you for your help. I put this on current and it highlights the "Enable" part in VB and says "Method or data memeber not found."

[carlyd]

Ok. Thanks I got it to work. Me.ComboBoxName.Enabled = False (forgot the d in enabled). But now I can't enter new data. I think I need to do an if/then statement?

[RuralGuy]

If Not Me.NewRecord Then
   Me.ComboBoxName.Enabled = False
Else
  Me.ComboBoxName.Enabled = True
End If

[RuralGuy]

Me.ComboBoxName.Enabled = Me.NewRecord

[carlyd]

Yes! Thank you RuralGuy! I appreciate your time and help. This really made my work life a little simplier!

[carlyd]

How do I post this as solved.

[RuralGuy]

How do I post this as solved.

At the top of the Thread under Thread Tools.