Double-clicking on a particular record to open up that record in a different form
I have been racking my brain over and over this code to allow an user to double-click on a particular record on my main dashboard screen to open up another form and go to that particular record that I double-clicked on.
The primary key has been set and I would want it to find that record in the other form based on the primary key. I can get the double-click to open up the form but it will not go to the particular record.
So my question is how can I put together code to all me to do that?