O'Reilly logo

Beginning Access™ 2007 VBA by Denise Gosnell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

14.6. Connecting the User Interface to the Code

You are now ready to tie everything you have done so far together by adding the VBA code to the Customer Search and View/Manage Customer Accounts forms. Most of this code will be event procedures that fire when different buttons are clicked. Some of the code will also be local procedures that deal with user-interface-specific features. It just did not make sense to put these in a standard or class module.

14.6.1. The Customer Search Form

An example of the Customer Search form, called frmSearch, is shown in Figure 14-27 with some sample data populated. Keep it in mind as you write the code for the form.

Figure 14.27. Figure 14-27

Try It Out: Writing Code for the frmSearch

As previously mentioned, you are now ready to write the VBA code that will finish up the application. Start with the frmSearch form, and finish with the frmCustomers form.

  1. Open the frmSearch form and select the Form_Load event for the form to bring up the Visual Basic Editor. Add the following code to the form:

    Private Sub Form_Load()
    
        On Error GoTo HandleError
            'create new recordset
        Set rsSearch = New ADODB.Recordset
            Exit Sub
    
    
    HandleError:
        GeneralErrorHandler Err.Number, Err.Description, SEARCH_FORM, "Form_Load"
    Exit Sub
    
    End Sub
  2. Add the following code to the General Declarations section of the form:

    Option Compare Database Option Explicit Const SEARCH_FORM = "frmSearch" ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required