Macro to open form to a sepcific tab?

[accessingaccess]

Hi!


I have a form with three tabs. When I open this form in add mode, I would like it to default to a specific tab. I was hoping to achieve this with a macro. Is this possible? I can't figure it out...


I'm using Access 2016.


Thank you!

 

[theDBguy]

Hi. I don't use macros much but try something like:

If [NewRecord]
  Set Property
    ControlName: TabControlName
    Property: Value
    Value: 2

Change 2 to which ever tab you want to assign. You may also have to start with zero (0).

 

[Deleted member 147267]

You could simply set focus to a control on the page and that page will be the active one when form opens. Probably doable wit a macro (I don't use them either so just guessing) but code would look like

Private Sub Form_Open(Cancel As Integer)

Me.NameOfControlHere.SetFocus

 End Sub

EDIT - forgot to mention that I didn't include a test for new record because how form is being opened wasn't specified. Could be OpenArgs or even a duplicate of a form that's just for editing or appending records (which isn't the best method) or some other undisclosed method.