Return focus to subform when report is closed

  • Thread starter Thread starter Sandi
  • Start date Start date
S

Sandi

Hi,
I have a form with a tabbed form. Each tab has command buttons on it
and also contains a subform.
I call a report from the command buttons. My problem is when I close
the report, focus is returned to the header of the main form which
contains my primary key for filtering clients.
I would like focus to return to the subform. Should I put some cold
on the close report event?

Thanks in advance!
 
You can set the focus in the report's Close event. You need two SetFocus
steps to do this (note that I'm using generic names):

Forms!NameOfMainForm!NameOfSubformControlOnMainForm.SetFocus
Forms!NameOfMainForm!NameOfSubformControlOnMainForm!NameOfControlOnSubform.SetFocus
 
Put focus to the object on the form right after the statment where you are
priting the report. e.g

DoCmd.OpenReport "Your Report Name"
Me.ObjectName_on_your_form.setFocus

I hope this will solve your problem
Click to expand...

Great, I will try those suggestions!
Thanks a lot!

Sandi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I close a subform on a report? 3
Report loses focus 4
Opening a report from a button on a subform 4
New Record in Form, Subform 1
Creating a report from a tabbed form 1
Errors in Report total fields 19
Report linked to subform in a subform 2
View/Print Individual Reports 16

Back
Top