by the user. This applies to other similar controls meant for dynamic texts in this Voucher Form. (xi) Paste another text box anywhere in the Form and set its Control Source Property as = Val(DMax(“Vno”,”Voucher”)) + and Visible property to No . Further, Set Default value property of Text box to the left of label Voucher No.
as =Val(DMax(“Vno”,”Voucher”))+ . This ensures that the text control generates a new value one more than the preceding value of the last voucher number entered in vouchers table as and when a new record is added. As a result, the voucher number is detected in Voucher table and incremented by one to auto generate the voucher number sequentially. Set its Enabled property to No for reasons already explained earlier.
(xii) Set Default value of Text box meant for entering the voucher date as = Now (). This results in displaying RTC date as the default date to voucher as and when a new voucher record is added. (xiii) Paste another text control below, the label Voucher No : to indicate Debit in case of Credit voucher and Credit in case of Debit Voucher. Remove its attached label and set its Font size and font weight property appropriately.
However, its Control Source property is set as = IIF([Type] = ,”Credit”,”Debit”) so that this text box displays the desired text as stated above. Pick up a List control from tool box and place it next to this calculated text control to choose the account. Immediately, the List control wizard gets activated and displayed. Complete the list control creation process as already discussed while designing the simple transaction form.
Ensure that its Control source property is assigned the Field name AccCode ; Row Source to Accounts ; Column Count set to ; Bound Column set to and Column width to . " . Re-size the control for proper display. Creating Grid for Debit/Credit Entries : The grid for entries is created by using SubForm Control.
Following steps are taken to create SubForm to be linked to Main Voucher Form : (i) Pick and