Calculated field not carrying into duplicate record

[karmacable]

I got some help (thanks to missinglinq) in another post on how to setup my code in a command button to duplicate a whole record, and then add on a revision #.

Now that I'm checking the duplicate records, all looks fine except a few textboxes where I'm using calculations...they're coming up as 0? The thing is, I've got them tied to Control Source on form's table, so if you open up the table you'll see the value from the calculations in their associated record.

So I'm still scratching my head, cuz if they're already in the table's record, why aren't they being copied?

It seems like there might be a general answer to this, but let me know if you need to see the code / structure of what I'm talking about...

 

[missinglinq]

Don't remember your exact problem (sorry, but I work on this and half a dozen other forums, 6-8 hours a day, and answer a dozen or more in a typical day) but for the Calculated Values I think you'll need to Recalculate them.

Immediately after your code to Paste/Append the copied Record use this line:

Me.Recalc

Linq ;0)>

 

[karmacable]

Thanks for the tip. I tried that without success, but then I tried referencing the function that I have doing the calculations after the Paste/Append, and it appears to have worked!