Help, I need my calculated field to go to my tabel!

[Sohaila Taravati]

I have this calculated field in my subform for each employee. So, when each employee is chosen, it calculates a Per Diem for each day based on their hours of work. I did an if statement in my query behind my subform that works perfectly.

I have a table where all this information is stored and I am trying to get the calculated field (Per Diem) to go into my table autmatically. In other words, everytime an employee is chosen it will automatically put my calculated field in my table. I don't want to use an update query.

Thanks,

 

[Rob.Mills]

I've done something similar. The easiest method I've used is to put a hidden textbox in the form that is bound to the field in your table where you want the calculated figure to go.

Then choose the event you want it this procedure to run on, maybe On Current, and tell it to set the value of the hidden textbox to equal the calculated control.

 

[Sohaila Taravati]

Thank you,
I have done something similar to this too, but I guess my mind went blank today

Thanks again