the top of right part of the Form. Access responds by invoking List Box Wizard, which provides for three options to choose the look up values. By default, the wizard provides for choosing look up values from table or query. Click at Next button to get the classified list of tables and queries to choose from.
At this stage, choose the Accounts table because domain of accounts to be debited or credited remains confined to accounts available in Accounts table only. Click at Next button to get the available fields of Accounts table: Code, Name and Type. Select Code and Name by clicking at > button. Click at Next to get a list of accounts with key column hidden.
Uncheck the already checked box to display the key column also in list control. Click at Next to get an option to select code to store in database. Clicking at Next provides two options: One to remember the value for later use and second to store that value in this field. Choose second option and select the debit field to the right of this option as the column against which the key value of accounts from list control is to be stored.
Repeat the above process to provide for a list control for Account to be Credited. Once both the List box controls for debit and credit entries have been pasted, change the caption property of labels attached to such List boxes and write the text “Choose the Account to be Debited” for first list box and “Choose the Account to be Credited” for second. Set the Font weight property to bold, the fore colour to red and green respectively to distinguish between debit and credit list control and re-size the label control by increasing its width to accommodate the text to caption of label. Re-size the list boxes to adjust their width and height appropriately.
This can be achieved by right clicking at each of the controls to get the property windows. (xiv) Click at Command button in Tool Box and carry the mouse pointer to Area at the