Link the Check Box Value to Text Box

[leem]

Hi

Can some body guide me how to Link the check box value to Text Box. below is the problem .

I've two options in the Check Box method where I've make a Option group for that to select the one value at a time .

1. Check Box1 is named as a "Selling"
2. Check Box2 is named as a "Buying"

I want to calculate the Total Freight from another TextBoxes
Selling Value and Buying Value . If Buying is selected at Check box option then freight will only calculated on "SellingValue" else on "BuyingValue" and that value will display / output come into Text Box named "Freight".

I've try the Function option and put the "IIF" condition but in that case system is taking the first condition if its true or false and giving the same value .

Please tell me where I'm wrong.

Thanks in adv. for guidance
leem

[PEB]

Hi,

Where is your IIF condition?

IT seems to be like
=IIF(Checked_Buying=True, [Buying Amount],[Selling Amount]) * Your formula...

Best regards!

:)