Charts

[James C.]

Can anyone help me with the following Chart Problem?

I am inserting a chart based on a query that I build. If I put the company
code into the query and then insert my chart into my form everything works
fine. However, I would like the chart to be dynamic.

On my form I have a company drop-down box that changes information on my
form specific to the company selected. This field is called ACCTLU. In my
query I put the following in the criteria under the company field
(Forms!FormMain!AcctLU).

I get an error when I open my form. I want the user to be able to select the
drop-down and the chart to refresh correctly. The error that I keep getting
is the following:

" The Microsoft Jet database engine does not recognize
[Forms]![FormMain]![AcctLU] as a valid field name or expression.

Does anyone know how I can do this without hardcoding it in?

 

[SteveD]

How I worked around this ... doing a make table query (or delete & append to
an existing table) then the chart always used this table. It worked out
great.

There are probably other means to skin this cat, but ... this is how I did it.

HTH
SteveD

 

[James C.]

Thanks a bunch. This got me going in the right direction. I did this combined
with setting the subform that my chart was on to Form.Chart.Recalc and it
worked great.

How I worked around this ... doing a make table query (or delete & append to
an existing table) then the chart always used this table. It worked out
great.

There are probably other means to skin this cat, but ... this is how I did it.

HTH
SteveD

Can anyone help me with the following Chart Problem?

I am inserting a chart based on a query that I build. If I put the company
code into the query and then insert my chart into my form everything works
fine. However, I would like the chart to be dynamic.

On my form I have a company drop-down box that changes information on my
form specific to the company selected. This field is called ACCTLU. In my
query I put the following in the criteria under the company field
(Forms!FormMain!AcctLU).

I get an error when I open my form. I want the user to be able to select the
drop-down and the chart to refresh correctly. The error that I keep getting
is the following:

" The Microsoft Jet database engine does not recognize
[Forms]![FormMain]![AcctLU] as a valid field name or expression.

Does anyone know how I can do this without hardcoding it in?