Record Locked (1 Viewer)

K

kitty77

Registered User.

Local time

Yesterday, 19:21

Joined

May 27, 2019

Messages

710

• Oct 15, 2019

• #1

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

I’m here to help

Staff member

Local time

Yesterday, 16:21

Joined

Oct 29, 2018

Messages

21,453

• Oct 15, 2019

• #2

Are you using PasteAppend?

 

K

kitty77

Registered User.

Local time

Yesterday, 19:21

Joined

May 27, 2019

Messages

710

• Oct 15, 2019

• #3

I created the button with the wizard, duplicate macro.

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 07:21

Joined

May 7, 2009

Messages

19,231

• Oct 15, 2019

• #4

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.

 

K

kitty77

Registered User.

Local time

Yesterday, 19:21

Joined

May 27, 2019

Messages

710

• Oct 16, 2019

• #5

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

 

theDBguy

I’m here to help

Staff member

Local time

Yesterday, 16:21

Joined

Oct 29, 2018

Messages

21,453

• Oct 16, 2019

• #6

kitty77 said:

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

Click to expand...

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