button to open a mask that contains tab control

[Gicu]

I agree, would you please show us a screen shot of your form with the two tabs and explain what should happen. For the Where condition to work you need to have a field called "ID" in the record source of the form being called and a control called ID in the calling form (the "Me.ID" part). If both are true (and both are numeric) then the (main) form will open at the record with the right ID. Now, if you have subforms on the tab pages and those are not linked to the main form via the ID field you would get what I think you're explaining. Depending on your subforms (single form vs continuous or datasheet) you will have to add lines of code to go to the desired record in the subform. But we can't really help much without seeing what you have....
Cheers,

[Miki52]

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.

Sorry, but I'm having a hard time following you.
The "button" is in a mask 1 with a text box named ID.
In a mask 2 is inserted a tab control with n 2 tabs.
In tab #2 is inserted a text box with name ID .
I would like with the button to open tab #2 of mask #2 and associate the ID of this tab with the ID of Mask 1.
I hope I have been clearer.

[Welshgasman]

Why do you call a form a mask?
What is the recorsource for Tab2?

[Gicu]

Does the record source for mask 2 have a field called ID with the value from the text box named ID in mask1? What you describe in post 17 should work with the code we discussed. Or do you want to create a new record in mask 2 for the ID from mask 1? Either way a screenshot would help.
Cheers,

[Gicu]

@Welshgasman Mask=Form in italian (masquera). If you set the Windows language to Italian even the VBA changes from Forms!... to Masquera!
And Google translates that into Mask in English.

[moke123]

Mask=Form in italian

I was wondering that myself. Thought it could be a form but wasn't sure. I was worried it was something I'd never heard of before.

[Miki52]

I think the translation certainly does not help understanding.
I decided to modify the structure of the Form, eliminating the tab control.
Thanks for the help.
I ask the organizers to close this thread

[Welshgasman]

I think the translation certainly does not help understanding.
I decided to modify the structure of the Form, eliminating the tab control.
Thanks for the help.
I ask the organizers to close this thread

That is for you to do, in Thread Tools, in green bar, top of page