Microsoft Support Online | Resources | Contact Us 
 
  Home | Create Database With Form | ODBC | ADO | Form Post | Form Retrieve | Hyperlink Retrieve | Hyperlink using Field | Display Image

Retrieve Information from a Database with a Form

In Microsoft FrontPage 2000, you can use the Database Results Wizard to create pages that let visitors display specific 
information from your database. To display specific information from
a database using criteria based on a form, follow these steps:

  1. On the File menu, point to New, and click Page.

  2. On the Insert menu, point to Database, and click Results



  3. In Step 1 of the Database Results Wizard, click to select the Use an existing database connection button. Click 
    to select Volcano2 from the list.



    Click Next.

  4. In Step 2 of the Database Results Wizard, make sure the Record source option is selected and Employees  
    is selected from the list. Click Next.



  5. In Step 3 of the Database Results Wizard, click More Options.


  6. In the More Options dialog box, click Criteria.



  7. In the Criteria dialog box, click Add.


  8. In the Add Criteria dialog box, click to select LastName in the Field Name list, and click to select 
    Equals
    in the Comparison list.



    Click OK.

  9. In the Criteria dialog box, click OK.

    In the More Options dialog box, click OK.

    In Step 3 of the Database Results Wizard, click Next.

  10. Click Next in Step 4 of the Database Results Wizard, and click Finish in Step 5 of the Database Results Wizard.

  11. On the File menu, click Save As. Save the page as "criteria.asp" (without the quotation marks).

Top


© 1999 Microsoft and/or its suppliers. All rights reserved. Terms of Use.