Navigation Forms and SubDatasheets/Subforms

I have created this great database tracking application in MS Access 2010 64-bit for my contract position. I am trying to figure out how I can double-click on the side of the datasheet for a particular record row where it will pull up the form that is associated with it and take me to that record to view it.

I can get it to open the form but not the specific record that I want to view.  Plus I would like to click on the navigation button, I would like to change the color to another color to indicate to the user that they are looking at that data and be able to have a label that just pops up with the name of the caption of the navigation button as well. Thank you.

Can someone help me? Thank you!
Who is Participating?
lauriecking0623Connect With a Mentor Author Commented:
I have resolved my own question finally.
Can you upload sample DB and explain actions and expected result?
ramromconsultant Commented:
"I can get it to open the form" - using VBA?

"but not the specific record that I want to view" One way - after open form add something like:
forms!formname.filter = "id = " & selectedID

Open in new window

where id = is the unique identifier of the desired record and selectedID is that of the record you double-clicked.

"the navigation button" what is that?

"a label that just pops up ..." please explain
lauriecking0623Author Commented:
I am using Access 2010 where we can create navigation forms so they could be used in an database application or on the web published through Office Web Apps. I used it as a main dashboard/switchboard.

I would like to be able to show the name of the button that is selected.

So across the top, I have Cases Requests Data Objects etc. as buttons. When I click them, I want to have a label or text box that will show the active button.

I hope that makes more sense.
lauriecking0623Author Commented:
I was able to figure it out on my own. I am very happy.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.