"Queen's" <sa**@post.queensu.ca> wrote in message
news:c5**********@knot.queensu.ca...
I have a database I'm working with which has tables and reports. The
controls in the reports are bound to data, but I'm at a loss to explain
where the data is coming from. I have gone so far as to delete the tables
of data, yet the reports are unchanged and show the same data as always.
Anyone know what's going on, and how I can get to the underlying data to
delete some of it?
What is in the Report's RecordSource property? You should be able to
examine that to see where it is getting it's data. It will either have the
name of a table or query or a SQL statement which you would have to examine
to see what tables and/or queries it is using.
If the RecordSource is blank then you have an unbound report which means
the controls themselves would either have to be unbound or at least bound
to functions that have a way to pull data from some other source. Any
unbound controls could also be getting populated in code running the
report's module. Actually, the report itself could have a blank
RecordSource property and then have a RecordSource applied in the report's
open event.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com