Search results for query: *

Correect me if i am wrong, but what I believe Dauntless0522 is trying to do is the following: For every well with the same ID (as there will be many matches), compare the top and bottom rock perfs to the t=rock tops & bottoms. If the well name matches and the perfs meet the crieteria, then...

Thank you for your time and bearing with my thread.

I find that calling the calculation in the "On Current" portion of the form properties does calculate the field every single time the record is viewed.... unfortunately, even if the value i the same as it previously was - it flags the form as dirty and prompts for a save every single time. I...

Update2 (no edit function?): I moved the sub call to right before it checks to see if the form is dirty, which makes the calculated value part of the me.dirty = true statement, rather then an after effect of it. This solves my problem! The only way this could be improved now is if those...

Update: I found that if I specifically call the 'after update' sub function in Field1 from Field2 or Field3, then it will update. The problem I now have is that I have code for my form under 'Before Update' that checks to see if the form is 'dirty', and then prompts the user to save. This was...

Hello all. I have several fields that are calculated from other fields. They are very simple calculations. My research has repeatedly shown that in an Access form, if I type in Me.Field1 = (Me.Field2 * Me.Field3) in the 'After Update" section, then anytime Field2 or Field3 is updated, this...