Solved I want to Show and Hide a field in a SubForm depending on the value in a field on Main form. (1 Viewer)

Local time
Today, 10:10
Joined
Aug 19, 2021
Messages
137
Hi,
I've created a voucher form to make different vouchers. There is a lookup field to select the Type of Voucher.
List of Voucher Types is:
  • CP-Cash Payment
  • CR-Cash Receipt
  • BP-Bank Payment
  • BR-Bank Receipt
  • PB-Party Bill
  • JO-Journal
  • SL-Sales
1652706491981.png

A subform named GeneralLedger is associated with this main form.
Below are the some of fields in the subform:
AccountCode, AccountID, InvoiceNo, ChequeNo, InvoiceDate etc.
1652707340505.png


I want to Hide ChequeNo field if VoucherType in the main form is:
CP-Cash Payment, CR-Cash Receipt, PB-Party Bill, JO-Journal Or SL-Sales

And I want to Hide InvoiceNo field if VoucherType in the main form is:
BP-Bank Payment Or BR-Bank Receipt
1652707499347.png


Thank you in advance.
 

Gasman

Enthusiastic Amateur
Local time
Today, 06:10
Joined
Sep 21, 2011
Messages
10,868
Still going ahead with the accounting db then?
 

Users who are viewing this thread

Top Bottom