I am trying the use the NodeCheck event for a tree control (as below), but Access won't recognise the event procedure.

Can anyone help?

Private Sub xTree_NodeCheck(Node As Node)

End Sub

I can tell you are a VB programmer. NodeCheck is not available in Access (VBA).

HTH

mmcdonal

Hi Michael,

Thanks for this. I have managed to get the Node_Click and Node_Checked events going in VBA. The MS help files are slightly incorrect in regards to the variable declarations for the event procedures.

In VBA the node must be declared as type object (not type node as specified by MS). You can then create a node type object and set the first to the second which allows you access to the automatic editor tools.

This seems to work for me anyway.

Private Sub xtree_NodeClick(ByVal node As Object)

    Dim oClickedNode As node

    Set oClickedNode = node

    With oClickedNode (etc.)

...

End Sub

Thanks,
Karen