Option group visible and invisible numerical fields

[xaysana]

Dear there,

Is there any way of using Option group check box to visible or invisible numerical fields please?

I have 3 numerical fields which are: Kipcurrency, ExchangeRate, and USD. While having Kipcurrency field as a default defined in Option group.

I have also 3 options in a option group which are: KIP, USD, and Baht. While KIP=1 Option value.

Now, what I would like to happen it is that, once I USD option check box, it hides Kipcurrency and ExchangeRate fields, if KIP is selected then it shows all those fields.

Thank you so much in advance

With warm regards,

 

[Dennisk]

use the After Update event for the option group and test the value and take the appropriate action depending on the value.

 

[xaysana]

Thank you so much for recommend.

Now, I have other issue poped up it is that: When I add new record or scrolling records up and down. it does not seem that it automatically toggles either turning off or on the currency fields.

I really don't have any idea to workaround, here I have posted a sample of db. if anyone could fix it please.

Thank you in advance

 

[Dennisk]

call the code in the forms on current event as well

 

[xaysana]

Yes, it works

Thank you so much in deep