Solved Allow adding a new record while restricting existing records on a popup form

[slharman1]

I have a popup form that lists records and has these fields:
CompID
Qty
Date
OrderDetID
I want to restrict the user from editing the existing records while still allowing them to add the new record.

Not sure how to go about this
Thanks

 

[theDBguy]

I am thinking using the Current Event would play into this. For example, in the Current Event, check if you are on a New Record. If so, allow edits; otherwise, disable it.

 

[slharman1]

I am thinking using the Current Event would play into this. For example, in the Current Event, check if you are on a New Record. If so, allow edits; otherwise, disable it.

Thanks
How would i code this?

 

[moke123]

Private Sub Form_Current()
    Me.AllowEdits = Me.NewRecord
End Sub

 

[slharman1]

Private Sub Form_Current()
    Me.AllowEdits = Me.NewRecord
End Sub

Cool, that was easy!