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" ...

Get Beginning Access™ 2007 VBA now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial