Heeelp! Very confused - calculated fields in my form wont go into the table

[authormum]

Please help! I am a newbie and VERY confused. I am not a programmer but am just learning so any help much appreciated! I'm not even sure if I've posted this to the right place?

I have so far created a table and also an asscoiated form - they both work! Changes in the form go into the table, no problem EXCEPT where I have a calculated field in the form - this info doesnt go into the table - how do I get this information to go back into the table?

I am trying to do this because I want to include the result of the calculated fields in a mail merge letter in Word (and Word wont pick up fields from my associated form - only from the table or from a query!)

Please rescue a damsel in definite distress (I've been knocking my head against a brick wall on this for 3 hours now!)

Many thanks in advance

 

[Mikk]

Im having the same problem, I have several check boxes that when ticked put a value in an unbound text box, these are then totaled in a final unbound textbox, i need that text box value to be saved in a field on my "request" table.

Does this sound like the same problem to you?

Mikk

 

[Mikk]

I think it need some sort of update query/coding but im not sure where to start! Ill keep trying at it and keep an eye out on here and post a solution when i find it

 

[CEH]

I am not well versed on the mail merge... Done it a few times... But if what you say is true and it will only pick up from table or query.. Then put your calculated field in the query. For example....... Looking at the QBE.... type into an open field... Total:[Field1]*[Field2]

 

[authormum]

Thanks from Authormum!

Thank you both, Mik and CEH - I have done as you suggested CEH and explored a bit and this does seem to work. I'm not finally there yet but I can see light at the end of the tunnel.
Your comments much appreciated.
Thanks

 

[MStef]

Hello authormum!

Look at "DemoFAUA2000.mdb"