Adding a Data Source to the form

  1. From the Data tab of the Toolbox, click the Data Source icon.
  2. In the workspace, click the upper-right corner of the form to place the Data Source icon.

    The Data Source icon is displayed in the upper right hand corner of the form. This control is not visible at run-time when the form is rendered.

    Place this control where the control does not interfere with other controls on the current form.

  3. Set the property values for the Data Source:
    • Name = dsSafetyGloveBal
    • Source Type = Query
    • Source Parameter = Set the Parameter property:

    In certain situations, the data source type “query” does not provide an efficient means to specify the data source—for example, if you want to use complex SQL queries. In these cases, you can use rowsources, which enable you to build an array list based on parameters or to manipulate an SQL statement. You must first define the rowsources before the rowsources can be displayed in the list of data source types (in the Type field).