different question regarding mouse scrolling... 1

[Chummly66]

Hey everyone,

First, is I do not want to disable the mouse scrolling. But because of that, I ran into something and was wondering if anyone could shed some light.

I have a form, which has a tab control. The control has 2 pages on it, and they are only visible depending on a combo box selection.

So, on my main form, I have Name, Phone number, and a combo box called "reason". Nothing else is visible after selecting New. Once I enter the name, phone and select an item from the reason combo box, either page 1, page 2 or both appear for data entry. When I finish entry, and click New, the form resets so neither page is showing and the process starts for the new record.

However, with the mouse scroll, you can go to the "next new" record and becuase of that, the pages never reset and are still viewable. Is there any way anyone knows of where if you do use the mouse scroll to go to a new record, the form still resets? Right now, I have the code on the Form Load event. Tried a couple of other events like Mousewheel, but still no luck.

thanks for any suggestions!
Richard

 

[BoxHead]

Try the form's Current event. That should fire whenever the form moves from one record to another.

HTH

 

[Chummly66]

Thanks a bunch Boxhead! that solved it!

 

[BoxHead]

Glad to help, Richard.

Thank you.