Record Locked

[kitty77]

I have a form that is set for AllowEdits = False, Oncurrent.
I then have a button that AllowEdits = True when I want to unlock the record. This all works fine.

But I also have a duplicate button that does not work because when it goes to a new record and tries to paste, its locked. It resets. Any way around this?

Thanks

 

[theDBguy]

Are you using PasteAppend?

 

[kitty77]

I created the button with the wizard, duplicate macro.

 

[arnelgp]

Edit your button's macro.
add new Action:

SetValue:
Item = [FORMS]![yourFormName].[AllowEdits]
Expression = True

now, move this action just below RecordGotoNew

at the end of the macro add another Action that will re-instate AllowEdits to False using SetValue again.

 

[kitty77]

Don't see a set value option in the macro?

 

[theDBguy]

Don't see a set value option in the macro?

Did you click on the Show All Macro Actions button on the Ribbon? Just curious...

 

[JOWINO]

Edit your button's macro.
add new Action:

SetValue:
Item = [FORMS]![yourFormName].[AllowEdits]
Expression = True

now, move this action just below RecordGotoNew

at the end of the macro add another Action that will re-instate AllowEdits to False using SetValue again.

Editing the buttons macro works pretty fine. It also bypasses the the allowedits and it can duplicate even without allowingedits.