open record from subforms

[ForumUser]

Hi,



I have a main form where I see some search results, below that I have two subforms in a tab. I want to use one button to open a record from the main form, or from one the subforms which I placed in a tab.
The search results are shown in the main form. The search records in the main form have nothing to do with records in the subforms. So this subforms are not linked to the main form.
I have the vba code to open the record from the main form, but I don't know the vba code to open a record from one of the subforms in a new form when clicked on the button.
Three buttons for main form, subform 1 and subform 2 are also good. This is button is in the form footer.

Thanks for the help!

[June7]

You want one button to serve for opening a record selected in either the main or subform? How should the code know which to reference? I suspect you need 3 buttons.

One on main form to open that record. One on each of the subforms.

[ForumUser]

Alright, thats also fine. I already have a button to open the record from the main form. Now the subforms, the link between both subforms and opening form is ID