View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Phil Smith Phil Smith is offline
external usenet poster
 
Posts: 50
Default No Record Source, no dependencies?

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