Beginning Access™ 2007 VBA

14.3. Building the User Interface

Let's create the empty forms for the user interface. You will then write the code in class modules and standard modules, and finish off by adding code to each form to call the class modules and standard modules.

Try It Out: Building the frmSearch and frmCustomers Forms Let's create the two forms that will be used by the application. Create a new form called frmSearch. Open the form in Design View. Next, drag the numerous controls onto the form and resize them, as shown in Figure 14-20. The following table will help ensure you have all the correct objects on the form. Rename the controls and change other properties for each object as shown in the following table. If you placed items on the form in a different order than described, your column default names may not match with the exact numbers shown below. Default Name on Figure 14-20 Name Type of Control Other Properties to Set from the Properties Dialog Form1 frmSearch Form Record Selectors = No; Navigation Buttons = No; Dividing Lines = No; Auto Center = Yes; Pop up = Yes; Caption = "Customer Search" Text0 txtCustomerNum Text Box Set corresponding label caption to "Customer Number:" Text2 txtPhone Text Box Set corresponding label caption to "Phone:" Text4 txtLName Text Box Set corresponding label caption to "Last Name:" Text6 txtFName Text Box Set corresponding label caption to "First Name:" Text8 txtCompany Text Box Set corresponding label caption to "Company:" Text10 txtAddress Text Box Set corresponding label caption to ...