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!