I have a form with an unbound entry text box. This entry text box is in the form to choose a date. After choosing a date it updates the recordsource of two subforms. One of the subform is a datasheet and the other is the same datasheet but displayed as a pivot chart. The chart displays the prices and the pivot chart displays the curve of the prices.
My problem is that every time I refresh the date of the form the curve of the prices are cleared. The items at the fields of the pivot chart are deleted.
How can I leave the items at the fields of the pivot chart freezed? So that when I refresh the date the pivot chart shows me the curve of the prices?
Anyone can help?
My problem is that every time I refresh the date of the form the curve of the prices are cleared. The items at the fields of the pivot chart are deleted.
How can I leave the items at the fields of the pivot chart freezed? So that when I refresh the date the pivot chart shows me the curve of the prices?
Anyone can help?
