Hey,
fairly new to vba. here is what i am trying to achieve in a nutshell. I want a user to be able to select a record from a listbox or combo box (values retrieved from a table). once they select that record I want it to run a select query (qrySelect) to retrieve the other attributes related to this record. Then I want it to open a pivot chart. (frmPChart) I have the chart format created and related to the query, right now I can manually enter the record in Criteria: and run both and its fine. Any thoughts and code help will be greatly appreciated!
Cheers,
Eric
fairly new to vba. here is what i am trying to achieve in a nutshell. I want a user to be able to select a record from a listbox or combo box (values retrieved from a table). once they select that record I want it to run a select query (qrySelect) to retrieve the other attributes related to this record. Then I want it to open a pivot chart. (frmPChart) I have the chart format created and related to the query, right now I can manually enter the record in Criteria: and run both and its fine. Any thoughts and code help will be greatly appreciated!
Cheers,
Eric
Comment