saving data just like control source?

[A|ex]

How do i save data in a textfield where i do calculations, if i was using a normal textbox which asked for simple text input i can add a control source and save it in that field in whatever table. If i add a calculation/ formula to a field i loose the control source option.

Same goes for when i make a text field = another text field. I want to store whatever is in that textbox to whatever table record. How is it possible?

Cheers

 

[WayneRyan]

Alex,

You don't want to store data that you can calculate. It will
make your life miserable as your database grows.

If you must, you can use the AfterUpdate event of your "unbound"
calculated field to:

Me.SomeDBField = Me.MyCalculatedField

But, just save yourself trouble in the long run and calculate
it in your queries.

Wayne

 

[A|ex]

what do you mean unbound it doesnt seem to be working.

Me.SomeDBField = Me.MyCalculatedField

Me.MyCalculatedField is the field on the form where you perform the calculation.

What is Me.SomeDBField is that the database table field i want to store it to?

 

[A|ex]

woohoo it works cheers