Alow edits 1

[samotek]

In my subform on the OnCurrent event i have a code that disallows editing:

Me.AllowEdits = Me.NewRecord



This code is perfect, since the user is not alowed to edit records already chosen.
I want to make an exception however, and that is when i want to allow changing the price.
In that case i want to allow the user change the price, and then again revert to the old situation when editing is not allowed
with new records.
However simply writing Me.AllowEdits = True does not help.
I must somehow make invalid the line
Me.AllowEdits= Me.NewRecord

So my question is can i both keep my code in my OnCurrentEvent and also make it false for a given event?
I have a special button called "PriceChange" where on clicking it i want to give this possibility.

 

[mp9]

Surely all you need is:

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

If you then want to restrict so that only certain fields are editable (which I think you do) use (and toggle, where appropriate) each control's Locked property.

http://www22.brinkster.com/accessory/

 

[samotek]

Thank you !!!!