How to change the control source in a report

  • Thread starter Thread starter Doglover
  • Start date Start date
D

Doglover

I need to make a change in the control source for a report for some
additional information from my DB. I've tried to make it in the "properties"
but have not been successful. Do I make it there, or is it made in the
query? I am working with a really old DB and also don't have a lot of Access
experience.
 
Hi Helen,

It depends....

If the control source in the properties window is the name of a query then
you make the change to the underlying query. If the control source in the
properties window is an SQL statement (would likely begin with SELECT), then
you change the SQL statement.

HTH
Sam
 
Back
Top