MS Access see detail Total when Focus on Total Field

[msilva100]

I have a "Total" on a Form of a Invoice amount: $3,000.

When I click on the "Total" field of $3000, I would like to see the detail charges that made up the $3,000.

09/15 Charge 1: $1,000
09/20 Charge 2: $1,000
09/22 Charge 3: $1,000

Thank you, I greatly appreciate your help.

[hvsummer]

that total I guess you sum with ID or CODE for each object, right ?
then image now you need to see where those total from, the invoice.

now, you need a combobox/listbox on top, on left or anywhere you need. (let call this ABC)

set row source to query that SELECT that ID/code and invoice's charges as field FROM table invoice.

Next, give the field ID/code this criteria Forms!nameofform!nameofID/codecontrol/box (/ mean or, id/code - id or code - explain, not the code's format)

point to the total box/field, on event, find the onclick event, give it this code vba

private sub box/field_click
me.ABC.requery
end sub
 

when you choose the ID or Code to see the total, detail about each charges on invoice will show in new listbox/combobox you have created.