Problem opening form to a specific record from subform

[bpepper82]

This subform is in a tab control. If I create the subform outside of the tab control, it works fine. Any idea why being in the tab control would cause this behavior?

[RuralGuy]

Hmm...Do you have any code or macros running in the Tab Control itself? How about a timer control running? I'm just guessing here.

[bpepper82]

There is no other code running in the tab control. There are two tabs, each with a different subform.

[RuralGuy]

Does the other tab subform exhibit the same symptoms? This is with Win7 64bit and ac2010 64bit, correct?

[bpepper82]

The subform in the other tab has no code on it. It is for users to enter notes, and they can do so directy in the subform.

I am using Windows 7 64bit and ac201064bit

[RuralGuy]

Put your Click code in the GotFocus or OnEnter event of the control on the SubForm and see if the results are the same.

[bpepper82]

If I put the code in either of those, nothing happens. It's like its not getting the focus at all. I did however find a workaround. I created the subform outside of the tab control and placed it over the tab. I then put code in the tab control changed event that hides the new subform when the other tab is selected. Not really an answer, but it is functioning the way I want now. I appreciate all the time you spent trying to help me.

[RuralGuy]

The tab control has a Click event that is practically useless. Comment out your Click Event code and see if the SubForm can get the focus.

[RuralGuy]

The Tab Control will get the Focus *before* the SubForm and could stop the SubForm from receiving the fucus.

[RuralGuy]

I guess you don't want to invest any more time in this issue but there is still something both of us do not understand about yoyr Tab Control. It would be nice to resolve that once and for all.

[bpepper82]

I guess you don't want to invest any more time in this issue but there is still something both of us do not understand about yoyr Tab Control. It would be nice to resolve that once and for all.

I've tried code in the got focus event of the subform and can't even get that to run. It's like the subform just can't be accessed. I confirmed that it is not locked and that it is enabled. I'm at a loss as to what else to try.

[RuralGuy]

Did you comment out the Click Event code yet?

[bpepper82]

Did you comment out the Click Event code yet?

Yes, I've tried everything you've suggested thus far. I'm still getting the same result.

[RuralGuy]

The Click Event is really a Mouse Event and not a Control Event. I suspect that it is not the best event for what you are trying to accomplish.

[RuralGuy]

You are no longer trying to open another form, right? Just displaying the ID value?