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

Similar Threads

Copy Total from one unbound field to a bound field 2
Copy text in a field from one to another. 1
Linking Unbound Field to Bound Field 1
Bound SubForm within an Unbound Form? 3
How force table update when no bound field updated? 1
Updating a bound form's record from an unbound form 2
Clear contents of an unbound text box on a bound form. 2
Populating a field in a table from an unbound field in a form. 5

Back
Top