SetFocus to report 1

[TSSTechie]

Howdy

I have a form and a report open at the same time. I need the report to have focus when both objects are opened and, if a button is clicked on the form, it immediately passes the focus back to the report.

I think I should be OK with where to put the command to achieve this. The part i'm struggling with is what the command should be. I've tried

Reports!Report1.SetFocus

but this does nothing, no error but the form keeps focus

Has anyone got any ideas how I can achive this ?

Thanks in advance

TSSTechie

May The Force Be With You

 

[HitechUser]

TSSTechie,

Not quite that simple, but try this...

http://support.microsoft.com/default.aspx?scid=kb;en-us;209938

Good Luck...

 

[VBslammer]

All you have to do is call the OpenReport action again - if the report is already open, it gets activated without re-querying its data.

Private Sub cmdFocusReport_Click()
  DoCmd.OpenReport "MyReport", acViewPreview
End Sub

VBSlammer

Unemployed in Houston, Texas

 

[TSSTechie]

Howdy

Thanks a lot to both of you for replying. I actually went with VBslammer's method but that doesn't mean i'm not grateful to you HitechUser for offering your solution.

Thanks again

TSSTechie

May The Force Be With You