change values after checkbox "YES"

[DonLduk]

Hello all.

Im currently building a DB with Access and Ive found myself coding simple VB lines (its been about 6 years since Ive programmed! im doing allright though.) in order to make it work as I want to, but I ran into a problem and im kind of stuck.



I have a Calls table with about 5 fields, one of them being "TARIFF VALUES".

Also I have a Details table which I have among the fields "Taxes in Tariffs" checkbox as well as a "Tax Value" textbox.

So, what I do is put the "Calls" table as a subform of the "Details", and what I need to have is that when I click the checkbox "taxes in tariffs" in the "details" table, the "tariffs value" field in the subform updates to the same value multiplied by the tax value
(tariff value * (1+ tax value in %))

and also if I uncheck it deduces the Tax value

I figured i'd put the code in the AfterUpdate event of the checkbox, but I just dont know how to tell it to access the subform field Tariff Value for take it and modify it in the

If taxChk.value=true then
Calls.???? = Calls.???? * (1 + details.???)



Can anybody guide me through? i'd really apreciate the help. thanks in advance!

[BamaBraves]

I would put something like this in the control source of the textbox of your subform.

IIF(Forms!Details!["Taxes in Tariffs"],(tariff value * (1+ tax value in %)),whatever)

I would remove spaces in field names.