troubleshooting Question

Set Focus using Global Variable

Avatar of LenaWood
LenaWood asked on
Microsoft Access
5 Comments1 Solution339 ViewsLast Modified:
This is an extension of this question:

https://www.experts-exchange.com/Databases/MS_Access/Q_21981827.html

The solution given worked on one machine but not another one (grrr sometimes I just LOVE my job).  Anyway, seems I am going to have to use a global variable to do this.

Do I use the global variable to set the focus on the report that is open?  If so, how?  I have already created the variable and called it strReportName.  In the on open event of the report, I have:

strReportName = Me.Name

Now how do I use this?

I guess I could use it to print the report by using DoCmd.OpenReport strReportName - but since the report is already open, would that cause an issue?

Thanks in advance for your help!
Lena
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros