Popup form being aware of a report in background ?

[Marc]

Hello,

I have a popup form I am trying to "make
clever" so it could behave accordingly reports
opened in the background.

Do you know how this popup form can retrieve
the name of the (open) report in the background ?
Have you some code doing this?

BTW, there is only one report opened at a time.


Thanks a lot
M.

 

[Pavel Romashkin]

Take a look at the Reports collection:

Reports.Items.Name

will have the name of report in question if it is open.
Cheers,
Pavel

 

[Cappy]

Using DAO

For I = 0 To Reports.Count - 1
MsgBox Reports(I).Name 'print name of any open reports
Next