Form (3) – VB code to add

Now that we have placed all the items in the form, it is time to add the VB code.

Just click the “View” button and select “Code” in the drop-down menu. The shortcut for this is F7 on your keyboard.

Depending on the object that was selected at that time in the form, the code window with the code for that object is opened. Since the textbox txtNaam was selected, we give the code for this object.

Remove all the code, and it gives “General” in the “Object” box.

Clicking on the downward pointing arrow next to the “Object” box (A), gives us a list containing all objects in our form. Clicking on the downward pointing arrow next to the “Declarations” box (B), gives us a list of all possible procedures that can be applied to an object. For example, the procedure “Click” is applied to a command button.

I’ve already posted the code in the code window. In the next lesson we will discuss this, but now that we’re here, we will go test it first. Just click the “Run Sub / User Form”, or click the F5 key on your keyboard.

This opens the form. Enter the details and click the Add button.

Once you have clicked the Add button, the data in the form is deleted and added to the table.

Click the “Close” button and you will return to the Visual Basic code window.

In the next lesson we will look at the code view.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats