Select start view tab in multitabbed form

[focosi]

Hello,
is there any solution to choose the tab in a multitabbed shown at startup according to the user who opens a user-level secured .mdb ?
Thx

[rpeare]

Yes, each tab in your tab control has a name if you go to a field on a specific tab your form will automatically choose that tab to start on.

[focosi]

Thanks for the hint. Is the following if statement ok ?

If CurrentUser() = x Then
Me.y.SetFocus
End if

[rpeare]

I don't know how your database is set up but if you have a function called currentuser that returns a permission variable then that might work though I prefer a specific

docmd.gotocontrol ("FieldName")

Access will find the field on the appropriate tab and go to that field

[focosi]

Thanks a ton rpeare. CurrentUser() is an intrinsic function of Access (at least 2007 on), just like Now(), so there is no need to create it. And yes, [tab element name].SetFocus works like a charm using a "Select" statement (more suitable than "If" statement since my workgroup has multiple users) in the OnLoad event for the tabbed form. Thanks again.