report recordsource?

  • Thread starter Thread starter BobRoyAce
  • Start date Start date
B

BobRoyAce

I've got this database from someone who wants me to take a look at it. Among
other things, it's got a bunch of reports in it that I need to look into
effort to modify. When I open them, it appears that the Record Source for
most of them is BLANK. Isn't the Record Source where one would specify the
table or query that the report is based on? There doesn't seem to be any VBA
code that sets the Record Source either. Is there some other place, or way,
where this could be specified? What am I missing?
 
I've got this database from someone who wants me to take a look at it. Among
other things, it's got a bunch of reports in it that I need to look into
effort to modify. When I open them, it appears that the Record Source for
most of them is BLANK. Isn't the Record Source where one would specify the
table or query that the report is based on? There doesn't seem to be any VBA
code that sets the Record Source either. Is there some other place, or way,
where this could be specified? What am I missing?
Click to expand...

Do the reports with a blank recordsource work?
What kind of data are they showing? Data, Pictures, a Graph?

The report's recordsource can be set using code, either in the
report's Open event:
Me.RecordSource = "select ...etc"
or via an event on a form:
DoCmd.OpenReport "ReportName", acViewDesign
reports!ReportName.RecordSource = "Select ... etc."
DoCmd.Close acReport, "ReportName"
DoCmd.OpenReport "ReportName", acViewPreview

Some types of reports, i.e. graphs, get their data from the OLEunbound
control that displays the graph, so the report itself may not have a
record source.
 
They are, in fact, all reports that show charts. So, I'll look for this
OLEUnbound control you refer to. Where would I find it? Is it that control
that has a recordsouce property?
 
Back
Top