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

[Khurramshaikh47]

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

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.

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

Thank you in advance.

 

[isladogs]

Use the AfterUpdate event for the VoucherType combo.
Set up your two conditions e.g. using Select Case statements to set the required controls in the subform hidden or visible.
See http://access.mvps.org/Access/forms/frm0031.htm for more info

 

[Gasman]

Still going ahead with the accounting db then?

 

[Khurramshaikh47]

Still going ahead with the accounting db then?

Gasman, Dear Now I am learning to grow!

 

[Gasman]

Now crossposted at https://www.accessforums.net/showthread.php?t=85961