onEnter event for control on subform

[dfwelch]

I have a data-entry form that I set up using the onEnter and onExit events to change the color of the question with the users focus is on the field for an answer, often a Yes/No combo. The problem now is that I have reached the limit for the number of controls on a form, and I am having to create a subform for the last 5 questions on the form.

So, I set the same onEnter and onExit events on the subform as the primary form. But, when I open the form, not only is the first focused control on the primary form getting the changes, but the first focused control on the subform is as well. Why is this happening and what can I do to change it?

 

[mph1]

Suggestion:

Since you have too many controls, instead of using a sub-form why not use a tab form???? It many be more convient and easier to use.

An investment in knowledge always pays the best dividends.
by Benjamin Franklin

 

[dfwelch]

I am using a tab form for just about the entire form. I didn't know that it was considered separate from the primary form in terms of counting the controls. I just tested it, and son-of-a-gun, it is! Cool, lemme see what I can do about that!