Automatic Chart

[neilw71]

Hi,

I want to design a chart for my boss where he selects a value from a combo box and clicks on a command button to open up a chart based on sales date just for that value.

Was thinking along the lines of some VBA to use the value selected to create a Table from "tblAllData" filtered by the selection. I could then have a chart pre built reading off that Table, opening automatically.

My problem is creating the table based on the value selected - the rest I can finish. Any ideas anyone ?

Thanks
Neil

 

[Aqif]

Hi

I dont think that creating table is necessary here. All you need to do is to create a simple query based on the value your boss enters on the form. The query should look like

QryTestGraph:
-------------
Select Field1,Field2 from MyTable Where Field1=Forms!MyBossForm!MyBossTxtBox

Save the query as Test Graph and in the RowSource Property of that graph use that query. I think this will solve your problem. Otherwise let me know in more detail.

Cheers!
Aqif