Show All

Add a form for searching a database

About creating a search form

You use the Database Results Wizard to create a form that enables site visitors to search for information in a database. The results of the search are displayed in a Database Results region below the form.

Create a search form to let site visitors search a database for specific information.

1  A site visitor enters an employee's last name in the Search for box of the form.

2  When the employee clicks Submit Query, Microsoft FrontPage checks the database to find employee records that match the name.

3  The records that match the criteria are displayed in the Database Results region below the form.

  1. Right-click the Database Results region, and then click Database Results Properties. The Database Results Wizard starts. Click Next to get to Step 3.
  2. In Step 3 of the wizard, click More Options, click Criteria, and then click Add.
  3. In the Field name box, select the field you want site visitors to base their search on, and then click OK.

    Note   Leave the Use this search form field box selected (it's selected by default).

    Tip

    Choose a field name that adds value to your site as a search criterion. For example, if your database contains employee last names in a column named LastName, you might want to add the ability to search for and display the record of every employee with a particular last name. To achieve this, add LastName to the Field name box.

  4. To add another field to the search form (to further refine the search), click Add, and then repeat step 2 of this procedure. When all of the fields that you want to include in the search form are displayed in the Criteria list, click OK twice to return to Step 3 of the wizard.
  5. Click Next twice to get to Step 5 of the wizard, select the Add search form check box, and then click Finish.
  6. To test your form, click Preview in Browser Preview in Browser button.

Note   Database integration features of Microsoft FrontPage work when your web site is hosted or published on a web server configured with:

Check to see whether your web server is configured with these options, or ask your Internet service provider (ISP) or web server administrator for assistance.