Date on report footer based on pop-up formcalendar on a form

[Fred's]

Hi Folks,

I have the Pop-up frmCalendar on my form to choose a date.

It is possible that when choosing the date from my Pop-up frmCalendar
that the date appear on the footer of my report.
If the answer is yes, how can I do that?

Thanking you all in advance for your help!
Fred's

 

[Tom van Stiphout]

On Tue, 18 Dec 2007 13:48:17 -0800 (PST), "Fred's"

Sure. There are several ways to do that. Perhaps the simplest is to
leave the form open while you open the report. Then in the report you
can have a control in the footer with a ControlSource of:
Forms!frmCalendar!MyCalendarControlName
(of course you replace MyCalendarControlName with the name of your
control)

-Tom.

 

[Fred's]

On Tue, 18 Dec 2007 13:48:17 -0800 (PST), "Fred's"


Sure. There are several ways to do that. Perhaps the simplest is to
leave the form open while you open the report. Then in the report you
can have a control in the footer with a ControlSource of:
Forms!frmCalendar!MyCalendarControlName
(of course you replace MyCalendarControlName with the name of your
control)

-Tom.







- Show quoted text -

Hi Tom,

I did what you said, but I have this error message" #NAME?

Fred's