Moving from a Subform within a Multi-Page Tab to a Selected Record and Tab

[Patch Spenceland]

Hi All

This is my first post so I hope I can explain things properly.

I have a Form named Clients with a multi-page tab named TabCtl0.

The record source tables’ primary key is [ID]

TabCtl0 has 7 tabs, the 1^st named General.

The 1st 6 tabs show information from the same record.

The 7th tab contains a subform named Focus displaying continuous forms with 3 fields in each record including [ID]

What I am trying (for hours and hours without success) to do is to create a Macro that fires when I double click on a control within subform Focus that takes me to the page named General and selects the record where ID = the ID within the selected record of subform focus.



If that is possible and anybody can help I would be extremely grateful.

I am using Access 2013

Many thanks,

[Patch Spenceland]

Well its surprising what a bit of perseverance can do.

After a good nights sleep and a good breakfast I gave it another go.

The solution was as simple as this!

Private Sub Field_Name_Click()
DoCmd.OpenForm "Client Details", , , "ID = " & Me.ID
DoCmd.GoToControl "Client"
End Sub

Happy days! :-)