How do I set an Event property of a control and save it in VBA?

[James Dudden]

So as the title says I am trying to set an Event property of a control and save it in VBA.

So in code I set a control's AfterUpdate event to target a function and then to close and save the form I use docmd.Close acForm,,acSaveYes but it doesn't save the Event properties.

Can anyone help with this?

 

[jdraw]

What exactly are you trying to set?

 

[James Dudden]

I am trying to set the AfterUpdate of a control to target a function (e.g.
=FunctionName) and then save it in VBA so the next time the form is opened and the button is clicked the function will run.

 

[James Dudden]

Figured it out - I needed to put the form in design view to save the changes.

 

[jdraw]

Glad you got it sorted out. Good luck.