Can data from text boxes be used to fill charts

[FireViking]

I have an unbound chart in a report and simply want to use data from text boxes instead of a query or table.
I cant find any code to perform this function.
Is it possible?

 

[mscraig]

I've done some work of this kind before and the two ways I found to accomplish the task were:

Assign the values of the text boxes to text variables.

1. Have chart data supplied by a Query which has criteria using the variables in a SQL string.

2. Put the text box variables into a table using the variables or text boxes in a loop and then supply the chart data from the resulting table.

While ------
rst.edit
rst![field1] = var1
rst![field2] = var2
'
'
'
rst.update
Loop