HandsOn Writing the Form CommandEnabled Event Procedure

1. In the Visual Basic Editor window, double-click Form_Sales Analysis Subform 1.

2. The Code window shows several event procedures you prepared earlier in this chapter. Enter the following Form_CommandEnabled event procedure below the last procedure code.

Part IV

Private Sub Form_CommandEnabled(ByVal Command As Variant, _

ByVal Enabled As Object)

If Command = OWC11.plCommandCopy Then If Enabled.Value = True Then

Debug.Print "Copy command enabled."


Debug.Print "Copy command disabled." End If End If End Sub

3. To test the above event procedure, open Sales Analysis Subform 1 in Form view. Because you've already created several event procedures for this form, various events will be triggered. Respond appropriately to the prompts. Once the form opens, switch to the Immediate window and examine the results of the events that were executed.

0 0

Post a comment