S
Steve
Im using Access '03 and I have a form with some options the user sets before
they click a command button that sets a graph to a subform. Initially, the
subform is hidden and it has no record source. When the command button is
clicked, it examines the options checked and assigns one of 12 graphs to the
subforms record source then unhides the subform.
The graphs are forms not reports. What I would like to do is cut down the
number of forms I have in the database, but I don't know what properties I'm
looking for. The graph forms use a query to generate their data. Is there a
way for me to change that query for the graphs then have my subforms record
source change?
I can write all my queries in SQL so I tried to use frmGraph1.rowsource =
'new sql query' but I could not access .rowsource inside the main forms code.
Sorry if this is unclear. What I thought would be a simple line of code or
two has me stumped so I can't explain my problem as well as Id like.
they click a command button that sets a graph to a subform. Initially, the
subform is hidden and it has no record source. When the command button is
clicked, it examines the options checked and assigns one of 12 graphs to the
subforms record source then unhides the subform.
The graphs are forms not reports. What I would like to do is cut down the
number of forms I have in the database, but I don't know what properties I'm
looking for. The graph forms use a query to generate their data. Is there a
way for me to change that query for the graphs then have my subforms record
source change?
I can write all my queries in SQL so I tried to use frmGraph1.rowsource =
'new sql query' but I could not access .rowsource inside the main forms code.
Sorry if this is unclear. What I thought would be a simple line of code or
two has me stumped so I can't explain my problem as well as Id like.