receive the value of amount of voucher. Text box, when bound to a particular field of the table, retrieves and displays the data stored in field for a particular row and is capable of modifying and adding data to the table. The unbound text box is used to get the data from the user for its subsequent use in report for providing report criteria. (c) List Box : This control is used for allowing a user to make a limited choice from a given set of values.
The domain of its values is predefined and therefore limited. List control may be used next to Debit and Credit labels in a simple transaction voucher, so as to locate the accounts to be debited or credited. (d) Combo Box : This control combines the features of a list box and text box by allowing a user to select an item from a list or enter a value using the keyboard. (e) Sub-form : Many Forms are based on more than one table with One-to- Many relationship.
The records of such tables can be displayed by creating form within a form, with tabular presentation of records. The Form within a Form (also referred to as Main Form) is called SubForm. The Main Form and SubForm have parent-child relationship. The Control used for creating such a child Form is called SubForm/SubReport.
Data records appearing in a grid can be stored in database by using SubForm Control. The SubForm whenever created is listed as an independent object like main form in Database Window. However, the SubForm Control in main Form has three properties for creating a link : Source Object : It contains name of the Form that is being displayed in SubForm control. Link Child Fields : These are the fields from the Child form that link the this form to the Main form.
These are also referred to as Foreign key of related table. Link Master Fields : These are the fields from the Main Form that link the Child form to the Main Form. These are also referred to as Primary