Forms

Forms can be used to:

• Display and edit data
• Control the application flow
• Accept input
• Display messages
• Print information

Various types of forms include:

• Multipageforms to store a large amount of information.
• Continuousforms for browsing through and editing a list of records, when each record has only a few data fields.
• Sub forms to show related data from the ‘many’ side of a one-to-many relationship.
• Pop-Upforms to provide information in a window that stays on top regardless of where you move the focus in your application.
• Modal forms to add functionality to your application.

How Can You Build A Form?

1. Click Form Tab.
2. Select New > Form Wizard.
3. Select qy:empAPP.
4. Click OK.

1. Select the fields.
2. Move them from Available fields to selected fields.

3. Click Next.
4. Select Columnar.

5. Click Next.
6. Select a style.

7. Type a title for the form.

8. To switch from Form View to Design View and back, click an option on the toolbar.

Michael now decides to populate the Job table. Since the job_code is formatted for Auto number, it is not necessary to retype the job code number.

To restrict the form user to selecting only jobs from this list:

1. Click Form tab.
2. Select Fm:application.
3. Click Design.
4. Click Job Code box.
5. Right click the mouse.
6. Select Combo Box > Change To.
7. Click the right mouse button> Select properties > on all tabs change the ‘row source type’ to ‘value list’. In the row source, type 1;2;3;4;5;6;7.
8. Click Close.

Michael’s form is ready.

Activity: Enter test data to see how the form populates your tables. Enter position titles for more than one person in the same job but with different skill sets. After you have entered the data, go back to the table tab and open up each table to see the one line entry. Open the Job table to verify that the job data previously entered is still intact.