Enabling and disabling fields based on multiple values from combo box

**hksahoo** · 10-23-2013, 05:16 PM

I have a combo-box with drop-down list to select with check boxes. The options are CASH, CHEQUE, DD, LETTER, PRAYER. One can also select multiple options like CASH and DD, CHEQUE and DD, DD and LETTER etc. I want that if DD is not selected then the DD_NO, DD_DATE, DD_AMT fields should be disabled. Similarly if only CASH is selected, then CHEQUE_NO, CHEQUE_DATE, CHEQUE_AMT and also DD_NO, DD_DATE, DD_AMT fields should be disabled. Pl. advise how to do it.

hksahoo

**June7** · 10-24-2013, 01:14 AM

This is a multi-select combobox for a multi-value field?

You have separate fields for CHEQUE, CASH, DD, LETTER, PRAYER?

If yes then your data structure is not normalized and will cause you a lot of problems and what you want might not be possible.

**hksahoo** · 10-24-2013, 07:08 AM

Ya.. this is multi-select combobox for multiple fields. For selection of "Cheque" in the combobox I Have three related fields like Cheque_No, Cheque_Date and Cheque_Amt. Similarly for selection of DD I have three related fields like DD_No, DD_Date and DD_Amt. If "Cash" is selected I have only one field "Cash_Amt". For the other two selections of "Letter" and "Prayer" I have only two logical fields(Yes/No) i.e. if "Letter" or "Prayer" or both are selected, then in the form, it should automatically show as "Yes". I wanted to send the database for your perusal but unable to attach as the size is more than 500 KB. So. Pl. advise what is to be done.