Private Sub Form_Current use

[Lou_Reed]

There is a tutorial on the web that states to start editing a form, one should add button on our form and name it btn_Edit.
Also give the button a caption Edit.

Put it under events in the property sheet for OnClick.



The initial code shown would be

Private sub btn_Edit_Onclick()

Me.AllowEdits=True

End Sub

Easy enough.

Now a subprogram to disallow edits whenever the user moves to the next record.

Private sub Form_Current()

 Me.AllowEdits=False

End Sub

Again thus us very straight forward.


That is the point of my question. I am not sure what this last subprogram does. It disallows edits.

But where does it disallow edits?

I am just not sure what the second subprogram does and how it does it.

Any help appreciated. Thanks in advance.


Respectfully,


Lou Reed

[NTC]

The stop-edit event occurs when one changes record. That is the definition of the Current event.

I myself do not recommend this approach of pre-locking a form. It locks the drop down selectors - which is one problem.

[John_G]

If the tutorial is showing the code just as you posted it, find another tutorial. Neither one of those subs will run when you think they do - they are not named correctly.

The first should be btn_Edit_Click(), and the second should be Form_Current(). Turning the edits off would not usually be done in response to a button click.

[Lou_Reed]

Okay, I have made some corrections. I believe that the sub programs are now correct.
I changed the edit_Form_Current() to Form_Current(). The original as written was incorrect.

My question is what triggers this action? I mean we know when editing of a record is enabled; when the button labeled edit is clicked.

But when is Form_Current() enabled?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[John_G]

You can't enable/disable events - they always happen. Whether or not you have a procedure for any particular event is up to you and depends on what your needs are.

The Form_Current event happens whenever you move to a another record on a form, whether it's a new or an existing record. If you need to take different actions depending on whether it is a new record or not, use the Me.Newrecord property (True if you are on a new record)

[CJ_London]

you might find this link useful

https://support.office.com/en-us/art...7-CE86553682F9