How to code the grand children?

December 8th, 2009, 03:28 AM

Suppose I create a Form in Run time say Form1, and add a control say cmd1. If the user clicks the cmd1 then we have to close the Form but how to attach code to that control, exactly an event procedure for that cmd1. I want to understand the fundamentals. Thanks in advance.

SerranoG · December 10th, 2009, 09:38 AM

Open the form in design view.
Click on the control.
Choose View > Properties from the menu
Choose the "Events" tab in the Properties window.
Place your cursor inside an event for which you wish to code, e.g. ON CLICK.
Choose "Event Procedure" from the dropdown menu that appears.
Click the button to the right with the elipsis (three dots ... ).
The VBA code window will open for that event.