saving data

[dawson321]

hi,

I am wondering if it is possable to copy data from feild to another automaticlly. This is becuase i have a caculated feild and a feild with a control source linked to a table.

What i want to do is copy the number in the caculated feild to the one with the control source in it so that the number is saved to a table so that it can be used in a report.

is it possable? if yes how can it be done?

thanks.

 

[G37Sam]

Why not just have the calculation done in the bound field from the beginning?

Can you elaborate on your scenario?

 

[dawson321]

Do you mean in the table?

 

[G37Sam]

No, I mean on the form itself man.

What are you trying to do exactly, can you please elaborate?

 

[dawson321]

i am mutilping a labour cost by the number of days worked but i want to figure to be saved so it is shown in the report.

 

[G37Sam]

Well you can use VBA, in both fields' [after update] events write:

me!totalcost = me!labourcost * me!numberofdays

Of course make sure the names of the fields match with the code

 

[dawson321]

That not workin this is what have got in

me!Total labour charge = me!labour charge per day * me!How many days labour

 

[G37Sam]

Upload your database (preferably a shrunk version) for me I'll do it for you and send it back

 

[Fasopus]

That not workin this is what have got in

me!Total labour charge = me!labour charge per day * me!How many days labour

You have spaces in the names, you neeed to either surround them like so:

me![Total labour charge] = ......

or change the names so there are no spaces

 

[dawson321]

i have surrounded the names but the code is still is not working.

Do you know another way?

 

[dawson321]

this is the database in a zip folder its on the job details form.

 

[vbaInet]

FYI: You really shouldn't be saving calculated values or values that are dependent on calculated values.

 

[dawson321]

y shoudent i

 

[vbaInet]

This would explain:

http://allenbrowne.com/casu-14.html

 

[dawson321]

G37Sam are you going to have a look at the database that i have uploaded?