How to change the control source in a report

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.
 
S

Sam Davis

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to change a control source for a report 2
Cross Tab Report Vs Dynamic coulmns 0
Calculating the Grand Total in the Report 7
Report Control Source Formula 2
change control source or value of text box 9
text box control source 2
Function in Control Source with Param 3
Change data source of existing report 1

Top