VBA on Subforms

[Dylan Snyder]

I'm trying to run a VBA code that calculates the value of the duty rate per unit when I input the Duty Rate. I have another form where I use this, and it works:

Me.Duty_Per_Unit = [FOB Cost] * ([Duty Rate] / 100)
Me.Duty_Per_Unit_LCL = [FOB Cost LCL] * ([Duty Rate] / 100)

But when I plug this into my new subform(on a totally different form) it doesn't update. It does not even give an error. Is there something else I have to do because it's a subform. I'm new to all of this VBA writing. I know my way around access fairly well, but VBA is all greek to me at this point

 

[pbaldy]

As long as the code is also on the subform, that should work fine. If you want to manipulate the subform from the main form, the syntax would be different. Here's a good reference:

http://www.mvps.org/access/forms/frm0031.htm