Control Source Hassles

[GregM]

Can anybody please HELP???

I have a form that uses expressions in the CONTROL SOURCE box to calculate values based on what the user enters into text boxes.

PROBLEM...How do I get these calculated values back into my underlying table?

I have a feeling it's got something to do with SetValue Action but I can't make any sense of the online help in Access 2000

Thanks in anticipation

 

[Rich]

Generally you should not store calculated values, add your expressions to a query and base the form on the query.
HTH

 

[MSUKevin]

GregM,

Generally, as Rich pointed out its not a good idea to store calculated values in a table...

However, that being said, if you feel you must do this try adding your bound fields to your form and setting their visibility control to no. Then in the afterupdate event on your calc. field set the code to something like:

Me.boundfield = Me.calculatedfield

You'll have to change the names to the field names of your controls. This works in A'97 and I believe it is the same for 2000, but you might have to change it a little...

HTH,
KEvin