Ridiculously easy request

[FoeHunter]

I have an access file that we use to keep track of all of our spending/ordering. Just for eye candy, I want to add a total of all the orders onto the main screen. However, I don’t know how to make a VBA code to run a tally when the form is loaded.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Here is all of the information that I think is required, if something is missing, please let me know
<o> </o>
Form to have info displayed on: “MainMenu” in the “TotalOrder” Textbox
Data is pulled from the “SupplyLog” table, information is in the “TotalPrice” Field
<o> </o>
Thanks in advance
<o> </o>
-Foe

 

[geospatial]

Are you displaying the data in a form, report, or just viewing the table.

 

[FoeHunter]

I want to just display the total of that field for all the records in the text box on the MainMenu form

 

[xenou]

Maybe a DSUM() formula would work in a textbox.

More:
http://www.bluemoosetech.com/microsoft-access-functions.php?jid=50&title=Access DSUM Function

 

[FoeHunter]

=DSum("[TotalPrice]","SupplyLog")

Exactly what I needed

Thank you