N
Nicholas Scarpinato
I should probably explain what I'm attempting to do first before I explain
the problem I'm having. I have a co-worker who is in need of an Access
database to assist her with her daily reporting and research. She has data
that she is currently appending to an Excel sheet and using to generate
multiple PivotTables for her reports. What I'm attempting to do is migrate
her reports to an Access database, but still maintain similar functionality
to the PivotTable.
This is the solution I've come up with. I have a form with a subform
(Child0) which displays a query based on a ComboBox in the form header. The
AfterUpdate code of the ComboBox sets the SourceObject of Child0. This
SourceObject is one of eight different queries. What I need to be able to do
is select information from the Subform and use the selected information as
the criteria in a second query-driven form. This will allow my coworker to
access detailed information from the report by simply selecting the row she
wants detail on and clicking a button on the form header. Can this be done
with a query as the SourceObject?
the problem I'm having. I have a co-worker who is in need of an Access
database to assist her with her daily reporting and research. She has data
that she is currently appending to an Excel sheet and using to generate
multiple PivotTables for her reports. What I'm attempting to do is migrate
her reports to an Access database, but still maintain similar functionality
to the PivotTable.
This is the solution I've come up with. I have a form with a subform
(Child0) which displays a query based on a ComboBox in the form header. The
AfterUpdate code of the ComboBox sets the SourceObject of Child0. This
SourceObject is one of eight different queries. What I need to be able to do
is select information from the Subform and use the selected information as
the criteria in a second query-driven form. This will allow my coworker to
access detailed information from the report by simply selecting the row she
wants detail on and clicking a button on the form header. Can this be done
with a query as the SourceObject?