Button to navigate between tabs

[Bradex]

Is there a way to have a button at the end of the first tab which will take the user to the next tab on clicking it?



Is the method different for a tabbed form and the tabs on a navigation form?

[ranman256]

You don't need a button,....the tabs are 'buttons'.
you can use hot keys...in the tab caption, put an ampersand before the letter to become a hot key.

[Bradex]

I know that one can click on the tab to switch.

But, it will be easier for an unaccustomed user to have a button at the end of the first tab to take him to the next tab instead of scrolling up and clicking the tab. Moreover, the button will act as a reminder that the form is incomplete.

[alansidman]

maybe this:

http://www.datapigtechnologies.com/f...abcontrol.html

[Bradex]

Yes, that's exactly what I want! But it is not working for me!

When I place the button, the command button wizard appears, I select Record navigation & Find next as stated. But when I try to use the button, I get this error message: You didn't specify search criteria with a FindRecord action.

[Bradex]

Here is the solution for this:

Previous button:

 
If Me.TabCtl0.Value = 0 Then
      Me.TabCtl0.Value = 8
   Else
      Me.TabCtl0.Value = Me.TabCtl0.Value - 1
   End If

Next button:

If Me.TabCtl0.Value = 8 Then
      Me.TabCtl0.Value = 0
   Else
      Me.TabCtl0.Value = Me.TabCtl0.Value + 1
   End If

I had 9 pages, hence I have used the number 8 (denotes 9th page) and number 0 (denotes 1st page) in the above code.

Remember, your pages are numbered 0,1,2,3,... by access even if they are labelled as Page 1,2,3,4,...


All credit goes to the guys who helped me out here.

[Bradex]

Here is the solution for this (It works on a tabbed form):

Previous button:

 
If Me.TabCtl0.Value = 0 Then
      Me.TabCtl0.Value = 8
   Else
      Me.TabCtl0.Value = Me.TabCtl0.Value - 1
   End If

Next button:

If Me.TabCtl0.Value = 8 Then
      Me.TabCtl0.Value = 0
   Else
      Me.TabCtl0.Value = Me.TabCtl0.Value + 1
   End If

I had 9 pages, hence I have used the number 8 (denotes 9th page) and number 0 (denotes 1st page) in the above code.

Remember, your pages are numbered 0,1,2,3,... by access even if they are labelled as Page 1,2,3,4,...


All credit goes to the guys who helped me out here.