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

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
 
W

Wayne Morgan

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
How force table update when no bound field updated? 1
Populating a field in a table from an unbound field in a form. 5
Form Level Code lower level not refreshing. 1
Clear contents of an unbound text box on a bound form. 2
Need to populate a field in my table from the value in an unbound 6

Top