Web Development·12,095 discussions

Access 2000 Parameter passed to chart

Locked

I have written a Make Table query which asks the user for a start and stop date. I then create a chart of the table’s selected data. How can I pass the user-supplied start and stop date to the title on the chart?

Topic

Access 2000 Parameter passed to chart

In reply to Access 2000 Parameter passed to chart

When you make the table, add the parameters as fields. Copy what you have in the criteria field to an empty column in the make table query. Since you haven’t given the column a name it will appear(I will pretend your criteria is [Enter Beg Date]
Expr1:[Enter Beg Date]
Do the same think for the End Date

Now go to the form where you created the chart.
Add a text field
Go the the expression builder
Point the field to the table made from your query and the specific field.

Then move the field(s) down over the existing Title on the Chart.You can change the background etc. so it will look like it is part of the chart.

If you want to concatenate the two fields, you can use a text field and do something like this under the control source.(Again I am making up your criteria fields to be
[Enter Beg Date] [Enter End Date]

=”The criteria for this chart is ” & TableName![Enter Beg Date] & “and ” & TableName![Enter End Date]

where TableName is replaced with the name of your table.

GoodLuck.

Access 2000 Parameter passed to chart

In reply to Access 2000 Parameter passed to chart

I did everything suggested but I get #Name? back on the chart. Any suggestions on what I can do to fix it? Please contact me at ddenenfeld@emrmc.org Thanks!

[Author]

Replies