Set focus on navigation window access 2010

I have an Access database where I have a navigation form (called frm_main) and then 4 navigation forms tied to the main form.  I have the fourth tab open and when I click on a field I want it to open the third tab at a particular record.

This isnt a standard openform and go to record.  I want to go via the main form.

How do I do this?  There is very little online to show someone how to do this.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
it will help if you upload a copy of your db and explain in detail what it is you want to happen.
mtrussellAuthor Commented:
I cant upload the db but I have a navigation form with horizontal tabs.  Each tab links to a navigation target name form.  When I am in one tab on a particular record, I want to go to this record in another tab.

Given I have to pass through the navigation main form, this isn't just a simple open form and go to record.
Rey Obrero (Capricorn1)Commented:
ok, then i can only give you the  format on how to reference a control in a subform

[Forms]![frm_main]![NavigationSubform].[Form]![<name of subform control>]![name of control]

Open in new window

there is also a command to navigate to subforms

docmd.BrowseTo(ObjectType, ObjectName, PathtoSubformControl, WhereCondition, Page, DataMode)

see this link for more detailed explanation BrowseTo
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Jeffrey CoachmanMIS LiasonCommented:
Note that Navigation forms are no designed to do what you are asking here, specifically.

This is why there is so little documentation.
If you use standard forms with tabs, ...then this is easy.

Also note that without a sample (as Rey requested), we are guessing as to the "context" here, a lot is not clear from simple written explanations.
For example:
Your question title  is about "setting Focus" on the navigation form, ...yet here you seem to be asking about "synchronization"
It is not clear exactly you are synchronizing to.?
Customers and Orders? Patients and Doctors?, Students and classes?
Are  these one to may relationships, or Many to many relationships?
Perhaps the synchronization would be better if done using a main-subform design...

But again, without any context, is hard to visualize what you have, and what you need.

Perhaps I am missing something , so lets see if another expert can help directly...

mtrussellAuthor Commented:
OK so more detail.

I have a form:  Frm_Main which has a navigation control on it with five tabs.  

tab 4 is called minutes and it is related to a frm called Frm_Connection.  
tab 5 is called minutes update which is linked to a form called Frm_ActionsUpdate.
Both forms have a common identifier called connection_id.

What I want to do is to be updating a minute and if I click a button it will go over to tab 4 and go to the record of where the minutes were taken.

I know how to do this with only forms but I am not sure how to go to a record with a navigation control in the middle, if that makes sense.

Let me know if you have any questions and I can keep providing more details.
mtrussellAuthor Commented:
I've been playing around with the browseto control but still can't make it work.  The openform is opening the form outside of the navigation control area.  I want to basically mimic clicking the other tab and going to a record.  If it is easier I can stip down a db to show you.   This is pretty standard stuff though.  I have been using mostly wizards up to this point and some simple VBA to make the front end work the way I want it to.
Rey Obrero (Capricorn1)Commented:
upload a strip down version.
Jeffrey CoachmanMIS LiasonCommented:
I'll let you continue on with Rey to avoid confusion...
mtrussellAuthor Commented:
did strip down version make it across to you?

jeff- no worries on your comments.  I really appreciate them.  ray is doing a great job and I think we might be close.
Rey Obrero (Capricorn1)Commented:
no file uploaded. you will see it if the upload is successful.
mtrussellAuthor Commented:
mtrussellAuthor Commented:
I think it is up there now.
Rey Obrero (Capricorn1)Commented:
here is the revised db.

double click on the M_ID to view the related records

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.