Re: How can I get a calculated control value from a form into the tabl

Tech-Archive recommends: Speed Up your PC by fixing your registry

Conrama wrote:
> I've got a control based on two other field names, and I want the
> calculation to be saved in another field. Is this possible?

Possible, but almost always a bad idea. If you can calculate it then it
doesn't need to be stored. All your table needs is the data in the fields
that your expression uses as operands. Using those the calculated value can
always be derived on the fly and that is the fastest and best way to do it.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com



.

Relevant Pages

  • RE: Form calculation based on the date - How to????
    ... Access can't find the macro 'txtTotalDollarAmount_Bound = ... "Could it be that the control source for the form's field is now no longer ... txtTotalDollarAmount or txtTotalDollarAmount_Bound ... ... date field and then run the correct macro calculation based on that date. ...
    (microsoft.public.access.modulesdaovba)
  • Re: .visible property not firing
    ... events was their timing in relation to the calculation of the control. ... Try the OnCurrent event of the main Form, and the OnCurrent each of the ... I want to compare that third calculation with a field on ...
    (comp.databases.ms-access)
  • Re: .visible property not firing
    ... events was their timing in relation to the calculation of the control. ... time to make the calculation then the comparison and it works perfectly now. ... Try the OnCurrent event of the main Form, and the OnCurrent each of the ... I want to compare that third calculation with a field on the ...
    (comp.databases.ms-access)
  • RE: Form calculation based on the date - How to????
    ... "iez44" wrote: ... "Could it be that the control source for the form's field is now no longer ... txtTotalDollarAmount or txtTotalDollarAmount_Bound ... ... date field and then run the correct macro calculation based on that date. ...
    (microsoft.public.access.modulesdaovba)
  • Re: calculation in a access 2000 form, i need help.
    ... Nordivan wrote: ... "Marshall Barton" skrev: ... function can not use a control name. ... number is in the calculation in some way it dosent work. ...
    (microsoft.public.access.formscoding)