Calcuating Values

[RuralGuy]

See if this sample gets you a little further along. It impliments what was in that link I provided plus a little.

[WhatnThe]

Oh My GOD RuralGuy that’s exactly what I needed. I want to thank both you and Rainlover. You both have been very helpful in answering my questions. I think most people would have quit replying a long time ago. You both truly do deserve your super mod titles. I think I now understand how it works after seeing it in action. I have been at this for over 5 hours now.
I have one last question before I mark this as solved about something “Rainlover” added to my form.
He place the code below

 Private Sub Form_BeforeUpdate(Cancel As Integer)
 Me.PcsProduced = Me.Lengths * Me.PPL
End Sub

It did work. It calculated the value and it was recorded when I clicked the add the record button. The only thing it did not do was display the value in the PcsProduced field.
Would the info in the link have made the above code display the value in the PcsProduced field. Would you tell me what would have made this code display its value in the correct field

[RuralGuy]

The code Rain supplied only stored the calculation as you saved the record. My sample bound the "calculated" field to the control on the form, set that control as locked and did the calculation in both the Current event and the AfterUpdate events of the two controls involved in the calculation. There are *lots* of ways to skin this cat depending on what you are looking for.

[WhatnThe]

Thanks RuralGuy. Now I am on my my other post and about opening a blank form when I launch my database then I am going to rest for a bit. I have marked this as solved.

[RuralGuy]

That's great! One alligator at a time.

[WhatnThe]

One alligator at a time.

That one was like Godzilla

[RuralGuy]

Not to Mothra! Learning just takes time. Relax a bit.

[Rory898]

RuralGuy just want to say thanks again. That page helped me out perfectly
This forums amazing