Change report reference

[Razor1]

When running several reports I need to change the report name (tmp_BookingsRegional)in order to update the caption.

Here is the code that I need to change:

Reports!tmp_BookingsRegional.Caption = rstReps!Territory &
& "ern Region Daily Bookings for " & WeekdayName(Weekday(Date)) & " , " & Date

Thanks in advance to any help provided.


Razor1

 

[PWise]

in the report open

dim rstReps as recordset
set rstReps= currnetdb.openrecordset "Select ... "

me.caption = rstReps!Territory & "ern Region Daily Bookings for " & WeekdayName(Weekday(Date)) & " , " & Date

 

[Razor1]

I have tried your suggestion and get invalid use of ME.

Any other ideas.



Razor1

 

[PHV]

Maybe this ?
Reports!tmp_BookingsRegional.Caption = rstReps!Territory & "ern Region Daily Bookings for " & WeekdayName(Weekday(Date)) & " , " & Date

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886