graph refresh

G

geebee

hi,

I have a form which contains a graph. The graph i based on the following
rowsource:

SELECT tbl_account_count_history.del_group,
Sum(tbl_account_count_history.countofstatus) AS SumOfcountofstatus,
tbl_account_count_history.popenterdt
FROM tbl_account_count_history
GROUP BY tbl_account_count_history.del_group,
tbl_account_count_history.popenterdt
HAVING
(((tbl_account_count_history.popenterdt)=CDate([forms]![frm_moving_graph]![from])));

I would like to know how I can automatically refresh the graph after the
user selects a new date from the [from] field.

How can I achieve this?

Thanks in advance,
geebee
 
Top