Subform of depreciation amounts

[Annette]

Good morning,

I would like to have a subform on a form that list detail depreciation
amounts. I know the purchase price of an asset, the assets life span
and a depreciation start date. Is there a way for me to create records
to populate a datasheet subform showing the depreciation amount? I was
currently thinking of writing the transactions to a depreciation
table, but thought displaying the information on the fly would be more
useful.

Is there a way to have a query create all these records and have that
be the recordsource of the subform?

Any examples or ideas would be most helpful.