On click event for Tab Control not firing

also check the names of your controls

That's the way that it is. [Event Procedure] is in the On Click event field on the Event tab of the Properties Window and when I click on the ellipsis I am taking to the appropriate subroutine in my code.

That is why this is confusing to me.

Do you have codes written on the VBA window.
Please post them so i could take a look if theres something needed to be revised.

when you click a tab in the tab control it is not the same as clicking the tab control itself. which is what the onclick event fires on.

when you click a tab it simply displays the controls on that page - then you need to figure out which page was clicked. pages are 0 based. so if you have a button on your form in its onclick event you can figure out which page of the tab control is active, the default property of the tab control is its active page:

Private Sub Command4_Click()

'pages start at zero

Select Case Me.TabCtl0

Case 0: MsgBox "This is Page 1"

Case 1: MsgBox "This is Page 2"

Case 2: MsgBox "This is Page 3"

End Select
End Sub

this help?

John

Here is the VBA code:

Private Sub TabCtl118_Click()
    DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
    Forms![frmParticipant].Refresh
End Sub

I have tried placing a break point on the DoCmd to ensure that it is really not firing, and it never breaks.

jbrienct,

Possibly. So perhaps I need clarification on what needs to happen to get the Tab contol On Click event to fire. I assumed that clicking anywhere within the control, on any tab or on a control on the tab would fire the tab control On click event. Is this not the case? If not, how would a user ever fire the Tab Control On Click Event.

Similarly, I have put the same code in the On Click events for each of the 5 tabs (pages) I have in the Tab Control. They never fire either. Is this related?

depending on what you are doing you may want to use

Forms![frmParticipant].Requery

instead

from mskb

SUMMARY
Although the Requery, Repaint, and Records Refresh items are different, you can use each of them to ensure that what you see on the screen is updated.
MORE INFORMATION
Requery
The Requery macro action updates controls, such as list boxes and combo boxes. It works for the form on which those controls exist only if you don't include arguments.


Repaint
Repaint is not related to data; it merely redraws the object or control. If there is data that has been updated in the underlying dynaset but is not reflected on the form, you cannot use Repaint.


Records Refresh
Records Refresh requeries the form itself, as opposed to any control on the form.

SidFishes,

that may be the case, I will look at changing it to requery....if I can get the darn event to fire.

BTW, is there a document somewhere the lists what events happen in what order?

I just tried this on one of my forms

Private Sub Page3_Click()
DoCmd.Close acForm, Me.name
End Sub
 and it close the form

Ok this is what is happening
When you click on the Tab portion the one where the label is, the tab just becomes active.

but clicking anywhere other than the tab portion where the label is, the event  on click fires.

"BTW, is there a document somewhere the lists what events happen in what order? "

http://support.microsoft.com/default.aspx?scid=kb;en-us;208781

You need to use OnChange event.  Select top-right-most corner of tab control to see it on the property sheet.

Mike

If eghtebas hadn't said it yet, I would have,....  Use the OnChange event to catch the change in tabs, the OnClick only detects someone clicking on the tab control.  Clicking isn't that specific an action.

But it is the click event that I want. Basically, I want to know when the user moves from the main form to the tab control. At that point I want to ensure the record from the main form is saved, before the user begins editing the information on the Tab control. Once the user is on the tab, I don't care whether they move from tab to tab.

So the click event, when a user clicks on the tab control best represents the event that I want to fire. If only it would actually go off.

eghtebas,

It seems your suggestion is where this is heading if there is no other explanation as to why the click event won't fire.

I'm with eghtebas on his suggestion to hide the tab control until after the user saves the top record.

If you use the onclick, EVERY TIME the user clicks on the tab, for what every reason you are going to fire a routine of some kind.

I have kept quite re. OnClick beacuase I agree with what I have read about it by the other good experts.  Depending on your exact senario, you maybe able to fire save command from OnExit event of thr last text box on the main form.

Mike

If there are Absolute Requirements that exist before the user can enter into the data control on the tab, AND those controls ON the tab are not needed to complete the main record.  The "Hide Tab til Save Button" simply makes the most sense to me.

If you are GOING to use the On click you have to devise an exit condition that you can use to pre-empt the routine in it's early stages.

Also keep in mind that there are interactions that can occur on the tab that won't fire the tabs click event, so depending on that to save your record is less then desirable. Mike has it right, if you need to save dat before allowing use of the tab control then do it explicity - in a save button that enables the tab control when its done.

John

hoenth,

Have a dummy tab as first tab (on this tab put company logo etc to fill it up, no data text boxes).  Now, in order to move to any other tab, OnChange event of the tab-control could be used to accomplish what you are trying to do.

Also, when you enter new data on the main form, make sure to bring up the dummy tab.

Mike

You all have made excellent points. I have decided to use eghtebas suggestion and use a save button.

Thanks for all of your help.

But I still don't get why the On Click event never fired.

so you have a tab ctl. and you add a click event and in it:

MsgBox "peek-a-boo"

and then you click the gray portion of the tab control to the right of the tabs, but on the same level. like the empty space where new tabs will appear if added.

works for me...

John