Moving between Tab pages

[Nimrod146]

Good Evening,

On the form of my Db I have a tab control with four tab pages.

My last field on 'Course' page is 'Complaints' and the first field on 'Customer' page is 'Company Name'.

However when I use the tab key after 'Complaints', it goes back to the first field on the 'Course' page. But I would like it to go to the first field of the next Tab Page ... which is the 'Company Name' field.

Does this make sense??

I have read in another thread about ME.[tab page name].SetFocus ... when I entered this as an event procedure - afterupdate, it came back as not finding the correct macro.

I would be grateful once again for any assistance.


Nim

 

[Davros]

i'm no expert but this is how mine works.

on the last combo/text box on your main form page [before you want to go to the tabbs page] place a text box under this combo/text box [hidden] and set the 'on_got_focus' event property to set focus on the first combo/text box on the tabbs page. make sure that the tab order goes to the hidden combo/text box after the last combo/text box on the main form

my code is;

Private Sub txtmove_GotFocus()
Tactile_Pressure_Test.SetFocus
'moves cursor to text field on tab page from main page
End Sub

txtmove is a text box hidden under another text box and is the last text box on the main form. when the cursor enters here it automatically goes to 'tactile_pressure_test' which is the first text box on the tabbed page

hope this makes sense?

 

[boblarson]

Or simpler still, put the code in the On LOST FOCUS event of the last text box on the tab.