HOW TO: Set Up User and Parameter Populated Criteria Fields in FrontPage 2000

The following article describes how you can use a hyperlink parameter in one frame of a frames page to populate the criteria in a database results region that takes user-defined criteria in a second criteria field. Please follow these steps in the order presented.

Set Up the Frames

First, you must create the frames page. To create the frames page, follow these steps:

1. Create a new web in FrontPage at the following location:
   http://localhost/framesasp
2. On the File menu, point to New, and then click Page. Click the Frames tab, and then select Vertical Split.
3. Click New Page for each frame.
4. On the File menu, click Save. Name the frames page as default.htm. Name the left frame left.asp and the right frame right.asp.

For additional information about frames, click the article number below to view the article in the Microsoft Knowledge Base:

Create Content for Left.asp

To create the content for the left pane, create the content on left.asp. To do this, follow these steps:

1. Click the left pane.
2. On the Insert menu, point to Database, and then click Results.
3. In step 1 of the Database Results Wizard, click Use a sample database (Northwind), and then click Next.
4. In the Record Source list, click Customers, and then click Next.
5. In step 3 of the wizard, click Edit List.
6. In the Displayed fields list, CTRL+Click each item in the list except CompanyName and Country, and then click Remove. Click OK, and then click Next.
7. Click Next.
8. Click to select Display All Records Together, and then click Finish.
9. Click to select <<CompanyName>>, and then press CTRL+K to edit the hyperlink.
10. Click to select right.asp from the list, and then click Parameters.
11. Click Add, and select CustomerID from the Name list. Click OK. Click OK again to return to the Create Hyperlink dialog box.
12. Click the Change Target Frame icon (pencil with ellipses), select the right frame, and then click OK.
13. Click OK.

Create Content for Right.asp

The right.asp page will contain two database results regions. To create the first database results region, follow these steps:

1. Click to select the page in the right frame.
2. On the Insert menu, point to Database, and then click Results.
3. In step 1 of the Database Results Wizard, click to select Use an existing database connection. Click to select Sample in the list, and then click Next.
4. Click to select Customers from the Record source list, and then click Next.
5. Click More Options.
6. Click Criteria, and then click Add. Click to select CustomerID from the Field Name list, and then click OK.
7. Click OK again, and then click Next.
8. Click to select List - one field per item from the Choose formatting options for the records returned by the query list.
9. In the List Options list, click Table. Click Next.
10. Click to clear the Add search form check box, and then click Finish.
11. Save each page.

To create the second database results region, follow these steps:

1. Click to select the page in the right frame.
2. On the Insert menu, point to Database, and then click Results.
3. Click to select the Using an existing database connection option, and then click Sample from the list. Click Next.
4. Click to select Customers from the Record source list. Click Next.
5. Click Edit List. CTRL+Click every item in the Displayed fields list, except ContactName and ContactTitle, and then click Remove. Click OK.
6. Click More Options.
7. Click Criteria. Click Add. Click to select CustomerID from the Field Name list. Click OK.
8. Click Add. Click to select ContactName from the Field Name list. Click to select Begins With from the Comparison list. Click OK twice.
9. Click Defaults. Click to select the first item in the Name column, and then click Edit. Set the value to 0 (zero), and then click OK. Repeat this step for each item in the list.
10. Click OK twice, and then click Next.
11. Click to select List - one field per item to select the formatting options.
12. Click to select Table in the List Options list. Click Next.
13. Verify that the Add Search Form check box is selected. Click Finish.
14. To view its properties, double-click the CustomerID text box.
15. Copy the text in the Initial Value box. (It should be similar to the following: <%=Request("CustomerID")%>).
16. Click OK.
17. Right-click anywhere within the form, and then click Form Properties. Click Advanced, and then click Add.
18. In the Name field, type CustomerID.
19. In the Value field, press CTRL+V to paste the contents that you copied in step 15.
20. Click OK three times.
21. Select the line that contains CustomerID and the text box, and then press DELETE to delete these items.
22. Save the pages by clicking Save on the File menu.