M
Mishanya
I have a Mainform (based on tblClientDetails) with subform (linked on
ClientID and based on some cubersome query with totals). The data in the
subform is conditionally formated (3 colours dependant on the groupnames).
Then I've created graph-Form based on the same query as the subform and
wanted to to put it on the same form, but Access does not let link form with
OLE object automatically to a motherform (and also does not let link it
afterwards from the properties), so I had to contrive - to copy the graph
from its motherform, paste it on the Mainform and then add [forms]![Mainform
]![ClientID] to the query criteria of the graph RowSource so it would update
whenever I update the ClientName combobox.
The I coloured the pie-sections in accordance with the conditional
formatting of the first subform - and here is the dissapointment. The pie
updates allright, but the colours are not consistent, meaning, they are not
conditioned.
1) Is there any "culturized" way to incorporate graphs as subforms and link
them with the maim filter?
2) Is there a way to conditionnaly format the graph's features?
3) or it's better not to indulge with graphs in Access, cuz it's its strong
side?
ClientID and based on some cubersome query with totals). The data in the
subform is conditionally formated (3 colours dependant on the groupnames).
Then I've created graph-Form based on the same query as the subform and
wanted to to put it on the same form, but Access does not let link form with
OLE object automatically to a motherform (and also does not let link it
afterwards from the properties), so I had to contrive - to copy the graph
from its motherform, paste it on the Mainform and then add [forms]![Mainform
]![ClientID] to the query criteria of the graph RowSource so it would update
whenever I update the ClientName combobox.
The I coloured the pie-sections in accordance with the conditional
formatting of the first subform - and here is the dissapointment. The pie
updates allright, but the colours are not consistent, meaning, they are not
conditioned.
1) Is there any "culturized" way to incorporate graphs as subforms and link
them with the maim filter?
2) Is there a way to conditionnaly format the graph's features?
3) or it's better not to indulge with graphs in Access, cuz it's its strong
side?