I'm sure this is not in any way an overly advanced procedure, but this is the situation. My Access skills are by no means advanced, but I do know a bit of VBA and have a cursory knowledge of SQL (I can read and understand it, but I could not write it from scratch -- so jealous of you kids who can).
Background
I have a personal financial accounts database, which lists 10 different financial accounts. The database has forms which allow me to record different activities (purchases, withdrawals, transactions, deposits).
Goal
The startup form will have the account holder's name and a listbox next to it that shows the account names (for simplicity's sake, let's say "Checking" "Savings" and "Cash").
Once an account is clicked on, I would like to show a subreport in the form based on the listbox selection, basically all transactions on that account in the last 10 days.
I also want to show a graph which displays my purchase types (my "purchases" table has a field for types of purchases, for simplicity, let's say "Food" "Transportation" and "Entertainment") in a pie chart.
Question
1) How do I make the form show nothing until a selection is chosen from the listbox, and then generate both the subreport and chart when I choose one of the accounts.
2) Where and how do I direct the chart/subreport to read that listbox selection on the form and create the corresponding parameter to create the chart/subreport?
Example
I start up the database, and up pops the startup form, with nothing on its face but my name and a listbox that shows the accounts "Checking", "Savings" and "Cash".
I click on "Checking", and on the left side of the form, there appears a 10 day activity report of all Checking account transactions. Then, on the right side of the form, there is a pie chart that displays the purchase types of the full account's history.
In both cases, the only parameter is the account.
Conclusion
I'm pretty sure this does not necessitate the use of a macro. I know this will involve using "Control Source", right?
I can fill out the details of it, but if anyone can either explain it, or give me directions on how to create a general simplified version of this, I'd appreciate it.
Background
I have a personal financial accounts database, which lists 10 different financial accounts. The database has forms which allow me to record different activities (purchases, withdrawals, transactions, deposits).
Goal
The startup form will have the account holder's name and a listbox next to it that shows the account names (for simplicity's sake, let's say "Checking" "Savings" and "Cash").
Once an account is clicked on, I would like to show a subreport in the form based on the listbox selection, basically all transactions on that account in the last 10 days.
I also want to show a graph which displays my purchase types (my "purchases" table has a field for types of purchases, for simplicity, let's say "Food" "Transportation" and "Entertainment") in a pie chart.
Question
1) How do I make the form show nothing until a selection is chosen from the listbox, and then generate both the subreport and chart when I choose one of the accounts.
2) Where and how do I direct the chart/subreport to read that listbox selection on the form and create the corresponding parameter to create the chart/subreport?
Example
I start up the database, and up pops the startup form, with nothing on its face but my name and a listbox that shows the accounts "Checking", "Savings" and "Cash".
I click on "Checking", and on the left side of the form, there appears a 10 day activity report of all Checking account transactions. Then, on the right side of the form, there is a pie chart that displays the purchase types of the full account's history.
In both cases, the only parameter is the account.
Conclusion
I'm pretty sure this does not necessitate the use of a macro. I know this will involve using "Control Source", right?
I can fill out the details of it, but if anyone can either explain it, or give me directions on how to create a general simplified version of this, I'd appreciate it.
