Getting text box data into a query/table

[kman42]

I have 5 text boxes that are all calculated in vb. They contain counts of record sources or totals of a subform sum or derivations of those. I want to create a chart based on the values in the text boxes, but I can't figure out how to get the data into a query or table to serve as the row source for the chart. Basically, I just want the values in three different text boxes to create a simple pie chart. What am I missing?



Do I need to create a one row table that will serve as the source for my chart and keep it around or is there a way to create a temporary table? Is there a table datatype in vb that I can use to make a table variable (like a recordset)? How would I populate it? I have a bunch of these little charts to create, so I don't really want a ton of one row tables sitting around.

I'm new to access and I feel that I am missing something really obvious so please forgive my ignorance.

Kman

[kennejd]

Couldn't you create a query that does the same calculations that are performed on your form?