MS Chart in Access form with dynamic SQL as data source?

[butbi]

I'm using now At Your Survey by Duane to make a survey. I want to
create a form with some list boxes to choose, one list for the
indicators and one for the respondents. The indicator will be the
SELECT parameter and respondent the WHERE parameter.
What should I do so if I click the submit button a new or a subform
will be open with the chart which the data source comes from this
dynamic SQL?

I try to follow the hints by StevenT to create a MS Chart for Access
form but don't know how to write the SQL statement, how to bind it to
the data source row for tha chart an how to write the OnClick event
for the initial form.

Thank you for any help. I need it urgently.

 

[Duane Hookom]

I'm not quite sure I know what you want to do. I do have a query by form
applet that allows users to select fields, set criteria, group by,... The
results fo the designed query can be easily sent to print, html, csv, Word
Merge, Excel, form letter, or a graph/chart.

 

[butbi]

Thank you for your reply.

I use your database AYS to input the raw data. Then I create some
queries to calculate several indicators. The query has following
structure:
respondent | country | indicator1 | indicator2.....| indicator n

In want to create charts by form with data source from a query like
that:
select [indicator x] from qryIndicators where [country]=countryX

(where indicatorX and countryX should be passed by form)

Can you give me some examples or hints (step by step, sorry I'm newbie).

 

[butbi]

Shoud I write code for an onClick event for the command button with
following steps:

- create/run SQL : SELECT [indicatorX] from qryIndicators WHERE
[country]=countryX
- create a chart with data source from this SQL
- create a form with above chart

If it the right procedure I have to do, can you give me some hints how
to realize these steps in VBA.

Thank you.

 

[Duane Hookom]

Sorry, some how I didn't provide the link to the site with my query by form
that creates the graphs etc.
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

 

[butbi]

Thank you, I will try to modify your applet and let you know later.