Navigation Forms and SubDatasheets/Subforms

Posted on 2012-08-17
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
    LVL 39

    Expert Comment

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

    Expert Comment

    "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

    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

    I have resolved my own question finally.

    Author Closing Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now