(un)locked

[matrixindicator]

Hey Everyone,

I have a Form on with the user select a customer. In the Form he shows the addresse of the customer. To avoid input of new customers along this form the fields with the addresse is locked. However, when he like to change a selected adresse he can unlock the access to the fields with a button.

 Forms![F01_ORDERS]!CUSTADRESSE.Locked = False

This works fine. He should lock the fields again automatically when navigating to a new or previous record in the form. What is the event to use, navigating to a new, a previous record, or leaving the existing record ?

 Forms![F01_ORDERS]!CUSTADRESSE.Locked = True

Thanks In Advance.

 

[kjv1611]

What is the event to use, navigating to a new, a previous record, or leaving the existing record ?

Since they are all separate events, I'd just put it in all 3. The reason is that any could occur, but may not always occur, therefore, putting it in all locations listed may be best....

Or another solution I use myself is to just put it in the On Load event of the form. You may have to also put it in an event related to "on refresh" or "on new record"...

--

"If to err is human, then I must be some kind of human!" -Me

 

[matrixindicator]

ok, grouping them together, but I wonder is there an event related to going to another record ? Any, like the previous, a new, number 52 ...

 

[PWise]

how about just this
Private Sub Form_Current()
me.!CUSTADRESSE.Locked = True
End Sub

and unlock it when you want

 

[TheAceMan1]

How are ya matrixindicator . . .

You can also use the forms [blue]AfterUpdate[/blue] event!

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]