Access is driving me nuts

[General Kenobi (ret.)]

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?

[Oracle]

12-step program for Obi-wan??

[General Kenobi (ret.)]

OK, any constructive thoughts?

(Memo to glenn: we need a CTM smiley)

[General Kenobi (ret.)]

Got it. I never got the distinction between the Text and Value properties before.