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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top