Hi,
I have a form in access which contains a number of sub forms in which information is to be entered thus the focus is on the textboxes in these forms. The problem is in order to scroll down to the other sub-forms contained in the main form the focus must be set to the main form. So in order to scroll I must click somewhere on the main form or use the scroll bar. This is quite annoying and I have not been able to find anything on google on how to fix this problem. Does anyone have any ideas? I was thinking maybe if there was some vba code for an On Scroll event but haven't been able to find anything.
Thanks.
Edit: I have tried Mainform.SetFocus in the OnMouseWheel event of the subforms but it doesn't work.
Edit1: Ok so Mainform.SometextBox.setfocus works but now it becomes very annoying while filling in forms as the current textbox being filled is deselected whenever you scroll so If anyone knows a better way of doing this I would appreciate it.