How to stop scroll action 1

[whill1]

Hi, this may have an answer not even pertaining to the scroll feature.
I have a mainform1A (user Info) with a subform1A (Details)in it. The problem is that when the form is opened the main form has the focus but is rarely updated. The subform is where 99.9999% of all editing/entries are made.
If say a (new) user opens the form it is very easy to hit the scroll button on the mouse and inadvertantly be in the wrong place (very bad!!).
I created a small Selectform1A with a dropdown box to select a user to open and filter mainform1A, this did not really get me anywhere although, I felt like I was on the right track.
Q1. Is there a way to set the focus to the subform when opened? This answer will help but if the user sets focus to the mainform again I'm at square 1.
Q2. Is there a way to disable the scroll feature on a mainform and leave it enabled on the subform?
Q3. Is there a way to lock the mainform so that you cannot leave the current record and have subform be in full edit mode.

 

[ClydeData]

On the forms Other Properties tab set cycle to Current Record

You could also have a look at the hook mouse wheel function from

http://www.lebans.com/mousewheelonoff.htm

hope this helps


Jimmy

 

[whill1]

Thanks Jimmy,
I stayed up late last night and got it to work. What I did was create a form with a dropdown box set it's AfterUpdate event to open and filter the mainform1A to a specific record when it opened. I then set the AllowAdditions property to NO on mainform1A. The only other thing I had to do is create a version of mainform1A (without any subforms)and set it's DataEntry property to YES. Basically the user has to set up an account before they can add details which is the way it really should be in my case.