mtrussell
asked on
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.
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.
it will help if you upload a copy of your db and explain in detail what it is you want to happen.
ASKER
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.
Given I have to pass through the navigation main form, this isn't just a simple open form and go to record.
ok, then i can only give you the format on how to reference a control in a subform
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
[Forms]![frm_main]![NavigationSubform].[Form]![<name of subform control>]![name of control]
there is also a command to navigate to subforms
docmd.BrowseTo(ObjectType,
see this link for more detailed explanation BrowseTo
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, ..as 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, ..it 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...
JeffCoachman
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, ..as 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, ..it 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...
JeffCoachman
ASKER
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.
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.
ASKER
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.
upload a strip down version.
I'll let you continue on with Rey to avoid confusion...
ASKER
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.
jeff- no worries on your comments. I really appreciate them. ray is doing a great job and I think we might be close.
no file uploaded. you will see it if the upload is successful.
ASKER
ASKER
I think it is up there now.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.