OnExit copy text from an Unbound field to a Bound Field VBA?

  • Thread starter Thread starter Vince
  • Start date Start date
V

Vince

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) as requested by
user for easy export into excel.

Please and Thanks ALL who continue to assist the newbies.

Vince
 
Yes, it can be done but is not needed for export to Excel. Make a query
based on this table you are wanting to export. Put a calculated field in the
query. Export the query to Excel instead of the table.
 
Back
Top