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!