This article assumes that you have already created a form and connected it to a database in your Web site. The described procedure is not recommended if you have created your form using the Database Interface Wizard and have chosen to create a Database Editor from within that wizard. For more information about creating forms or database management, see Microsoft FrontPage® Help.

Let's say you have created a form and have set its properties so that the form results will go to a database and then will be displayed on a results Web page. If you want to change the form (for example, to add a field), it might seem like a daunting task to update both the database and the page on which the results are displayed.

For example, you may have created a form on your site that asks site visitors for their names, addresses, and telephone numbers, and this form is hooked up to a database. However, if you want to change the form — for example, to gather your visitors' e-mail addresses — you will first have to add that e-mail form field to the form itself, somehow connect it to the existing database, and make sure that the information shows up on your results page, too.

With FrontPage 2002, there is an easy way to update both your form and the results page with just a few clicks. And you don't even have to go into the database.

Add new fields to an existing form and connect them to the existing database

1. Open the page on which you have created a form.
2. Add the desired fields and labels to your form, and set the properties of the form fields.
3. Right-click the form, and then click Form Properties on the shortcut menu.
4. Select the Send to database option, and then click Options.
5. Under Connection, select the database that you've already connected your form to, and click Update Database.
6. Click OK three times to exit the dialog box.

Update the database results page to reflect the changes made above

1. Open your database results page.
2. Double-click the area at the top of the page that says This is the start of a Database Results region.
3. Select Use an existing database connection, and make sure the correct database is selected (the one connected to the form you just updated).
4. Click Next, and then click Next again.
5. Click Edit List.
6. Under Available Fields, the name of the field you entered should be listed.
7. Select it by clicking it, and then click Add.
8. Click OK, and go through the rest of the wizard, specifying how you want your results displayed on the page.

Now, when your site visitors browse to your form, the new form field will be there, and the results they enter will appear on the form results page.