A
andrews
I have set up a report to open a form when the report is open. The form is used to control the content of the report via filters that utilize drop down boxes as input. The issue that I am having is that when I open the form, the focus remains on the report
I tired in the report open event after opening the form from the same event to do the following
Forms![My Form Name].SetFocu
Forms("My Form Name").SetFocu
And a couple other syntaxes that I can't remember at the moment. I also tried tossing a VBA.DoEvents after the open command and before the SetFocus command
The other thing I tries was putting a Me.SetFocus into the form open event. None of these things set the focus to the form, the report remained highlighted and the form remained greyed out. Note: the form IS in front of the report and will remain that way no matter how many times I switch back and forth, it just doesn't have focus
I tired in the report open event after opening the form from the same event to do the following
Forms![My Form Name].SetFocu
Forms("My Form Name").SetFocu
And a couple other syntaxes that I can't remember at the moment. I also tried tossing a VBA.DoEvents after the open command and before the SetFocus command
The other thing I tries was putting a Me.SetFocus into the form open event. None of these things set the focus to the form, the report remained highlighted and the form remained greyed out. Note: the form IS in front of the report and will remain that way no matter how many times I switch back and forth, it just doesn't have focus