Amal Nagm

• Forms that are based on this form template must be filled out by using Microsoft Office InfoPath. If the form will be filled out by using a Web browser, the form cannot submit data to a database directly. To configure a browser-compatible form template (browser-compatible form template: A form template that is designed in InfoPath by using a specific compatibility mode. A browser-compatible form template can be browser-enabled when it is published to a server running InfoPath Forms Services.) to submit data to a database, use a data connection that submits data to a Web service that works with the database.
• The primary database table that is used in the main data connection contains a primary key, unique constraint, or unique index.
• Any other database tables that are used with this main data connection have a simple relationship to the primary database table.

• Change the text that appears on the Submit button on the Standard toolbar and the Submit command on the File menu.
• Change the keyboard shortcut for the Submit button on the Standard toolbar and the Submit command on the File menu.
• Create custom messages to display to your users when they submit their forms.
• Specify whether to leave the form open, close the form, or open another blank form after the form is submitted.

Step 1: Enable the submit data connection

1. On the Tools menu, click Data Connections.
2. In the Data Connections dialog box, click the main data connection, and then click Modify.
3. In the Data Connection Wizard, click Next.
4. On the next page of the wizard, select the Enable submit for this connection check box, and then click Finish.

Step 2: Configure the submit options

1. On the Tools menu, click Submit Options.
2. To change the name of the Submit button that appears on the Standard toolbar and the Submit command that appears on the File menu when users fill out the form, type the new name in the Caption box in the Submit Options dialog box. Tip If you want to assign a keyboard shortcut to this button and command, type an ampersand (&) before the character that you want to use as a keyboard shortcut. For example, to assign ALT+B as the keyboard shortcut for the Submit button and command, type Su&bmit.
   
3. If you do not want people to use a Submit command or the Submit button on the Standard toolbar when they fill out your form, clear the Show the Submit menu item and the Submit toolbar button check box.
4. By default, after users submit a form, InfoPath keeps the form open and displays a message to indicate if the form was successfully submitted. To change this default behavior, click Advanced, and then do one of the following:
   • To close the form or create a new blank form after the user submits a completed form, click the option that you want in the After submit list.
   • To create a custom message to indicate if the form was successfully submitted, select the Use custom messages check box, and then type your messages in the On success and On failure boxes. Tip Use a message in the On failure box to tell users what to do if they cannot submit their form. For example, you can suggest that users save their form and contact someone for further instructions.
     
   • If you do not want to display a message after the user submits a form, clear the Show success and failure messages check box.