button to open a mask that contains tab control

[Miki52]

Hello,
I would like to insert in a mask a button to open a mask (MASK) that contains a tab control (CtrlSchede) and activate page 2 of the tab control


I tried to enter the following code on click of button:

Private Sub Pulsante_Click()
DoCmd.OpenForm "MASK!CtrlSchede.Value = 1".....
End Sub

but I have an error return for mask not found.


What’s wrong with the syntax of the code?

[Micron]

easy enough to tell you but you'll learn more by finding resources and reviewing them
https://learn.microsoft.com/en-us/of...docmd.openform

[Miki52]

Sorry,
I was not clear.
I know the syntax of the cmd Open Form, but I wanted help using it in my case.
I have initial knowledge of access...

[Welshgasman]

You are opening a form
Clear and simple.
If you want to assign a value to a control when the form opens, do so in the Load event of the form.

To select a tab control, you would set focus to it.
https://www.google.com/search?q=setf...obile&ie=UTF-8

Nowhere in the open form command is any option to do what you are just making up.
It is called a language for a reason.

[Miki52]

Ok.
Avevo alcuni dubbi che si potevano fare con il comando openform
Questa operazione verrà eseguita nell'evento Load del modulo.
Grazie

[Welshgasman]

Ok.
Avevo alcuni dubbi che si potevano fare con il comando openform
Questa operazione verrà eseguita nell'evento Load del modulo.
Grazie

Non comprende. Lo siento.

[Miki52]

Sorry,
I have posted the untranslated version.. I am in Italy.
Here is the correct version:
"Ok.
I had some doubts that the operation could be done with the openform command of a module.
I will execute the operation with the Load event of the module to open.
Thank you

[Gicu]

Just a note, you do not have to do it in the Load event of the form in case setting the focus to a specific page of the tab control is a "one-off" instance as I assume it would be in your case (otherwise you would simply make that the first page of the tab and no code would be required). You simply need to set the value of the tab control immediately after you opened the form by using a reference to it

Private Sub Pulsante_Click()
DoCmd.OpenForm "frmYourForm".....
Forms!frmYourForm.CtrlSchede.Value = 1 'assumes CtrlSchede is the tab control
End Sub

Here is a related link:
https://www.askwoody.com/forums/topi...a-tab-control/
Cheers,

[Miki52]

Just a note, you do not have to do it in the Load event of the form in case setting the focus to a specific page of the tab control is a "one-off" instance as I assume it would be in your case (otherwise you would simply make that the first page of the tab and no code would be required). You simply need to set the value of the tab control immediately after you opened the form by using a reference to it

Many thanks for the suggestion.
Very, very useful indeed.
I have another problem.
In the Open Form command I would have entered a Where like this:

"[ID]=" & Me![ID]

How do I put it in this context?
If I put it in OpenForm the command does not complain because it does not indicate the right Tab of the control cards. Can you give me another suggestion?
Sorry my English, I’m in Italy
Thank you

[Gicu]

You do it exactly the same, but you add the Where clause to the DoCmd.OpenForm to open the form (mask) to the desired ID then on the next line you assign the value of 1 to the tab control to show the second page (tab page indexes being 0 based).

Cheers,

[Miki52]

This operation doesn’t work.
The reference [ID] is in tab 1, which opens after the Openform command with the Where.
The Openform command is successful, tab 1 is activated, but the condition of the [ID] is not respected.

[Gicu]

Please show us the code exactly how you have it.
Cheers,

[Gicu]

Should be something like this:

Private Sub Pulsante_Click()
DoCmd.OpenForm "frmYourForm", , , "ID=" & Me.ID
Forms!frmYourForm.CtrlSchede.Value = 1 'assumes CtrlSchede is the tab control
End Sub

[Miki52]

Should be something like this:

Private Sub Pulsante_Click()
DoCmd.OpenForm "frmYourForm", , , "ID=" & Me.ID
Forms!frmYourForm.CtrlSchede.Value = 1 'assumes CtrlSchede is the tab control
End Sub

That’s right, this is the code.
The condition Where is before the activation of CtrlSchede=1
CtrlSchede=1 does not activate with [ID] required

[Welshgasman]

Well if you have subforms on each tab it will not. The Where is for the Mainform?
Likely need to issue a FindFirst of the recordsetclone for your tab control subform. Or perhaps just setfocus to the subform control if they are linked by Parent & Child.