Im trying to setup a rudimentary dashboard. I have some unbound text boxes that I would like a value to appear in. I have one portion working fine. Basically, I want the copied code to display in each of these unbound text boxes.
Private Sub Form_Load()
Me.Record_Count = DCount("*", "Assets")
Me.AssetValue = DSum("[Sale Price]", "Assets")
The Record count one obviously gives me the number of asset records I have in my asset table. What I am trying to do next is have the code display a currency formatted sum. So it would automatically sum all the sale prices in the assets table.
What am I missing? I am racking my brain on this. I know it's something simple. Right now it just gives me that error.