Copy Total from one unbound field to a bound field

[Vincent]

Hi,

I am a VBA Dummy.

Can someone help me with some code...maybe OnExit or what
ever YOU SUggest....what I need to know is how to copy
data that is currently a total in an unbound calculated
field (ChequeTotal) to populate another field
(InvoiceAmount), they should always be equal?

They in the same table. The bottom line is I need this
total stored (eventhough NOT conventional).

Please and Thanks ALL who continue to assist the newbies.

Vince

 

[Ronald W. Roberts]

me!InvoiceAmount=Me!ChequeTotal

You should check the events in help. I'm not sure the OnExit event is
what you
want. The OnExit event is a control event, not a form event. At the
form level, look at
the BeforeUpdate, Unload, OnCurrent and Close events. The unbound
calculated field (ChequeTotal)
will never have the focus because of that and because it is unbound,
most if not all other events will not fire.

Ron
..

 

[Kevin Sprinkel]

I suggest the AfterUpdate event of all bound controls
which are included in the calculation, ChequeTotal.

However, and excuse me if I rant, but I've yet to see the
instance where you must store an amount that is
- easily calculated on the fly in a query more quickly
- takes up no disk room, and
- does not risk one being out-of-date with the other

Even if your boss or client is suggesting (or demanding)
it, I think it's worth a discussion.

HTH
Kevin Sprinkel
Becker & Frondorf