list control are used to select an account to be debited or credited (the complementing account) against the accounts being mentioned in the Entries Grid are also calculated text controls. The calculated text controls acquire the text value to display on the basis of what is selected in the Option groups. Next to calculated text box control is a label to print an instruction for refreshing the display in grid. The grid consists of five columns: S.No, Code, Name of Account, Amount and Narration.
The grid appears in the voucher by using SubForm control. Besides this, there are five command buttons, each dedicated to Add Record, Undo Record, Delete Record, Save Record and Close. These command buttons operate on the data entry Form. Fig.
. : Credit voucher created as a form in access To create this voucher Form, following steps are taken using design view : (i) Create a blank form in design view and ensure that its underlying data source is selected as VouchersMain table and Field List window along with tool box is also displayed. As already discussed in Section I of this chapter, the Compound Voucher Form requires another related data table, VouchersDetail , for storing the data contents of grid. (ii) Keep the Ctrl key pressed and click at Vno,Vdate, AuthBy and PrepBy fields in Field List window.
(iii) Press at any of the selected field’s area, drag and drop it to blank Form. It can be observed that all the selected fields are also dragged and dropped along with this field. (iv) Re-position all the controls to their desired location in the Form and set the font weight property of each to bold. The caption property of each label can be modified to match the pre-printed layout of the voucher.
(v) Paste Option group control just below the form space meant for dynamic title. Access responds by prompting the user to enter the label names for each option. Enter two options by writing Debit and Credit in different rows. This must be followed by a click at Next button.
(vi) Option group