Learn how to a build a cloud-first strategyRegister Now


Navigation Forms and SubDatasheets/Subforms

Posted on 2012-08-17
Medium Priority
Last Modified: 2012-08-24
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!
Question by:lauriecking0623
  • 3
LVL 40

Expert Comment

ID: 38307336
Can you upload sample DB and explain actions and expected result?
LVL 17

Expert Comment

ID: 38307697
"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

Author Comment

ID: 38310164
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.

Accepted Solution

lauriecking0623 earned 0 total points
ID: 38310231
I have resolved my own question finally.

Author Closing Comment

ID: 38328499
I was able to figure it out on my own. I am very happy.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question