General Kenobi (ret.)
02-01-2002, 10:53 AM
I have this huge form. When the user selects a line of business, the LOB control has a change event that populates the form with the appropriate coverages for that line.
This form can print out reports for a number of states, so I'm trying to automate the process of stepping through states, then through coverages. But I'm running into a problem.
If I change the value of the LOB control from VBA, it doesn't trigger the change event and the coverage section doesn't update. "No problem," I said to myself. "I'll just use SetFocus and SendKeys to manipulate the form."
It works, too, except that if I switch applications while the VBA is running (for example, if I decide to check in on the Rebel Forum), SendKeys happily sends its keystrokes to whatever the foreground application may be (for example, Internet Explorer).
Any thoughts?
This form can print out reports for a number of states, so I'm trying to automate the process of stepping through states, then through coverages. But I'm running into a problem.
If I change the value of the LOB control from VBA, it doesn't trigger the change event and the coverage section doesn't update. "No problem," I said to myself. "I'll just use SetFocus and SendKeys to manipulate the form."
It works, too, except that if I switch applications while the VBA is running (for example, if I decide to check in on the Rebel Forum), SendKeys happily sends its keystrokes to whatever the foreground application may be (for example, Internet Explorer).
Any thoughts?