Subform visible and invisible help

[xaysana]

Dear there,

I got a quick question on a Subform. Please see an attachment.

What I would like to do is:

1. Whenever the option check = 1, the TotalStandingUSD2 becomes invisible if it equals 2 then the TotalExpenseUSD invisible and TotalStandingUSD2 becomes visible. I tried:

If Me.Frame135=1 then
Form!MySubformName.SubformField.visible=false

Else
Form!MySubformName.visible=True

End If.

2. In the Total Standing USD field appears #Num!, when it OtherCurrency field =0, Would that be possible to hide this?

Thank you so much in advance

Regards,

 

[boblarson]

No attachment made it.

 

[xaysana]

Ooooop! Sorry.

Here are attachments.

 

[xaysana]

Hi there,

I feel a bit disappointed on this forum. I posted few thread but no body response.

Is there anybody there?

Cheers,