Button click did not run in the subform

[Linda]

I have a main form with Tabbed forms. Within a specific tabbed form
called "Form2" I have a subform called frmOWNER which has a SAVE
button. But within frmOWNER I have 8 subforms, frmLEVEL1 through 8.
On one of the 8 subforms, when a user inserts a record, the SAVE
button is clicked. However, you must double-click in order for it to
work.

MainForm.Form2.frmOWNER.frmLEVEL1

How to resolve the double-click issue? Why didn't it work with just a
click?

 

[Klatuu]

In which event is your code to save the record?

 

[Linda]

The Click event. Which apparently works fine the very 1st click if
the cursor wasn't in the Subform's subform called frmLEVEL1.

 

[Klatuu]

Okay, that explains it. The first click is to move from the subform to the
main form and the second fires the click event. I don't know of any way to
get around this.
You can test my theory by clicking anywere in the main form except on that
button, then click on the button. I think it will fire then. But, that
doesn't resolve the problem.

 

[Linda]

Yes that's definitely the case. But I need a fix.

 

[Klatuu]

I don't know of any fix to do that. When you are in the subform, you have to
take some action to return to the main form. That means code to set the
focus to a control on the main form or clicking somewhere on the main form.
As to putting code to move the focus, I can't offer a suggestion without
knowing how your subform operates.

 

[Linda]

Oh, I just noticed something. Only when the subform frmLEVEL1 is
being entered the very 1st time does the 2 clicks apply. Once records
are already saved. If you go in to enter another record, you only
need 1 click.

 

[Klatuu]

Interesting, but I would have to set up a test environment to figure out why.