Copy data from one field to another (1 Viewer)

t0pk4t

New member
Local time
Today, 06:26
Joined
Jun 20, 2014
Messages
5
Good afternoon
I have a single table / single form on the form we are entering amounts in two fields

Split Net Values
Total Net Value

We then have a further two fields

Split Gross Value - which is a calculated field based on Split Net Value plus 20%
Total Gross Value - which is a calculated field based on
Total Net Value plus 20%

I have a further two fields

Actual Split Gross Value
Actual Gross Value

I need to copy the Split Gross Value into the Actual Split Gross Value but still be able to amend the figure.

Also need to copy the Total Gross Value to the Actual Gross Value and yet again be able to amend the figure.

Help please
 

burrina

Registered User.
Local time
Today, 08:26
Joined
May 10, 2014
Messages
974
Working with calculated fields can be tricky! By amend, do you mean to edit directly or have it update after the calculated values change? If the values change you would need to do a requery depending on what event the code fired.

Me.ActualSplitGrossValue = (Me.SplitGrossValue)+(Me.TotalGrossValue)

HTH
 

t0pk4t

New member
Local time
Today, 06:26
Joined
Jun 20, 2014
Messages
5
Thank you but I don't need the two fields added together I just need the data in both cells in the other two cells but only as a copy - with no calculations etc.

At which point if i need to amend the copied data i can.

Hope that helps

T
 

burrina

Registered User.
Local time
Today, 08:26
Joined
May 10, 2014
Messages
974
So, are you not able to edit what I posted and make it work? Remove the + Criteria and amend!

Good luck With Your Project!
 

t0pk4t

New member
Local time
Today, 06:26
Joined
Jun 20, 2014
Messages
5
This may seem like the dumbest question on this formum but where do i put this code?
Thanks
 

Users who are viewing this thread

Top Bottom