Multiple Control Sources

[BK]

Hello,
Is it possible to have a field with a control source that is not the control
source of the rest of the report? I need to be able to put the date in the
report header (and I have multiple reports, so I don't want to have to do
this manually every time I update) and I would like the control source to be
from a separate table with just the date field. So far every time I change
the control source for one field in the report, it changes it for the rest of
them.

Thanks!

 

[Marshall Barton]

Is it possible to have a field with a control source that is not the control
source of the rest of the report? I need to be able to put the date in the
report header (and I have multiple reports, so I don't want to have to do
this manually every time I update) and I would like the control source to be
from a separate table with just the date field. So far every time I change
the control source for one field in the report, it changes it for the rest of
them.

How do you expect to identfy the date in the "other" table?

The idea is to use a control source expression that does not
need to be changed. For example, you could use the
expression =Date() to get the current system date. The
various Date functions can be used to extract just the month
or manth and year. Or maybe youcan just format the current
date to ignore the day of the month.