link a graph to a drop-down list

[titiakila]

Hello everyone,

I want to display the values in a graph for the categorie "Histogramme 1" for example by choosing the categorie in the scroll-down list.

How can I do that ?

I will put the image in the comments



Thank you very much.

[titiakila]

I cant put an image.
I want to display the amount of sales by year for example but choosing for which product by choosing the product in a list

[June7]

A graph RowSource can reference a control in WHERE clause, example:

SELECT M, D, FD, ZD, ZDM FROM GraphProctor WHERE LabNum=[tbxLabNum];

Post your graph RowSource if you need more help.

[titiakila]

I tried to put a where condition in the source query of the graph but I add an error
"the database engine does not recognize the list name as a correct name or expression"

[June7]

As I said, provide RowSource if you need more help.

If you want to provide db, follow instructions at bottom of my post.

[titiakila]

I'm sorry i cant provide my original db so i tried with a test one. I just found out how to upload it it's bellow in my last post. But I only want to know if there is a solution for my problem. I want to know what vba code should I put when the event change the selection on the list happend. Sorry I'm french I don't understand everything in english. Thank you in advance.

[titiakila]

the test data

[titiakila]

the graph I want to make an action on

[titiakila]

db.zip
my test database

[CarlettoFed]

In the attachment you can see an example to get what you want.
DB.zip

[June7]

Use this SQL as graph RowSource:

PARAMETERS [Modifiable0] Text ( 255 );
TRANSFORM Sum(Requête1.sales) AS SommeDesales
SELECT Requête1.year_sale FROM Requête1
WHERE (((Requête1.product)=[Modifiable0]))
GROUP BY Requête1.year_sale
PIVOT Requête1.product;

[titiakila]

Thank you very much. Unfortunatly I cant download this database frome work.
I tried the sql query you wrote and to put it as the source of my graph and I have the following error message :
the selected query does not contain enough data to create a chart or the fields cannot be extracted. select a table or query containing at least one numeric date or text field

[Welshgasman]

Here is the SQL from CarlettoFred's DB

SELECT tblSales.YearSale, tblProducts.IDProduct, tblProducts.Product, tblSales.Sales
FROM tblProducts INNER JOIN tblSales ON tblProducts.IDProduct = tblSales.IDProduct
ORDER BY tblSales.YearSale, tblProducts.Product;

Rowsource for graph is

TRANSFORM Sum(qrySaleProducts.Sales) AS SommeDesales SELECT qrySaleProducts.YearSale FROM qrySaleProducts GROUP BY qrySaleProducts.YearSale PIVOT qrySaleProducts.Product;

HTH

[titiakila]

Just to be sure the rowsource is a query you select when you make the graph ?
Thank you very much.

[titiakila]

And in the code you wrote I don't see the where condition to select the value from the list is that normal ?