I have an invoice form that I am trying to get to calculate frieght but only if I check a box, frieght is only charges overseas. The frieght will equal ([cost]*.03). I just dont know have to get it to do this using a check box, can any one help.
Wrangler
Windows 7 
Access 2007
I have an invoice form that I am trying to get to calculate frieght but only if I check a box, frieght is only charges overseas. The frieght will equal ([cost]*.03). I just dont know have to get it to do this using a check box, can any one help.
Competent Performer
Add a textbox control to your form. Assuming that the checkbox is named Intl and that the base price is named Price, then use this formula as the ControlSource for your new textbox:
=[Price]*IIf([Intl],0.03,0.00)
For good measure, set that textbox up as Enabled=False and Locked=True.
BTW, you would be well advised to not hard-code that international freight rate, and instead store it in a database table...
Posting Permissions
Reply With Quote