I have a chart. It may be based on one of several different queries. I
am not sure which. I also can not find out which. If I right click and
choose "Object Dependencies", it says there are none. If I open it in
design view, and choose properties, the value for "Record Source" is blank.

All of the queries it may be based on rely on criteria pulled from a
dropdown on a form. If I open it without that form being open, I get a
prompt for the value, if I open the form, the results change as I change
the selected value of the dropdown. So it is obviously based on something.

I have done a compact/repair. What the Hell?

Now, I could make a copy of the database, and start deleting queries
until it fails, but that is not the point.

Access 2003 SP2

Phil

Sorry, realized this went into Excell charting, not Access...MY apologies.


Phil Smith wrote:
I have a chart. It may be based on one of several different queries. I
am not sure which. I also can not find out which. If I right click and
choose "Object Dependencies", it says there are none. If I open it in
design view, and choose properties, the value for "Record Source" is blank.

All of the queries it may be based on rely on criteria pulled from a
dropdown on a form. If I open it without that form being open, I get a
prompt for the value, if I open the form, the results change as I change
the selected value of the dropdown. So it is obviously based on something.

I have done a compact/repair. What the Hell?

Now, I could make a copy of the database, and start deleting queries
until it fails, but that is not the point.

Access 2003 SP2

Phil