Using Tabs in access

[Ludington]

I am trying to do a refresh after a tab is selected on my form with no luck.

The only event options I have showing on the tab are as follows:

On Click - This event does not work. I can't even display a message here. Example: MsgBox "Made it here"

On Dbl Click
On Move Click
on Mouse Move
On Mouse Up

I have read about others having the same problem which was solved by using the On Change event which I don't have.

Please help...Ludington

 

[ZmrAbdulla]

Private Sub TabCtl0_Change()
    Select Case Me.TabCtl0.Value
    Case Is = 0
        MsgBox "Tab 0"
    Case Is = 1
        MsgBox "Tab 1"
    Case Is = 2
        MsgBox "Tab 2"
    Case Else
        MsgBox "Other tab"
    End Select
End Sub

Zameer Abdulla

 

[Ludington]

Zameer under what event would I put your code?

 

[HarleyQuinn]

The Change event, go into the Visual Basic Editor and in the left drop down (at the top) select your tab control, then in the right drop down select your event (Change).

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

http://lessthandot.com

 

[Ludington]

Harley,

Where do I access the Visual Basic Editor from?

The following property event options are all I have on the data tab selected:

On Click
On Dbl Click
On Move Click
on Mouse Move
On Mouse Up

Still Confused...Ludington

 

[HarleyQuinn]

It's where you put the code for the events. In design view of your form press Alt+F11 and you'll be in it.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

http://lessthandot.com

 

[PWise]

Ludington:

Please note that the change event is on the tab control not on the page

 

[Ludington]

Thank you Zameer, Harley, and Pwise.

That was it. I was clicking on the page instead of the tab control.

Have a great day you made mine.