Right Click to make record 'current'
Posted on 2016-07-19
I have a continuous form in Access 2003 application. The shortcut menu bar is set as ‘MainRightClick’ in the form properties. ‘MainRightClick’ has all the options available for all lines on the continuous form.
Approximately twenty rows of data fit on the continuous form. If the user right clicks on any record showing on the form, the record that they were hovering over when they right clicked becomes the current record and the right click menu pops up. Any action selected from the right click menu is executed on the record where the right click occurred, because it became the current record. This is exactly the way I want it to work.
I am putting together a new Access 2013 application with a form that I want to work the same way. It is a continuous form with the ‘Shortcut Menu Bar’ defined as ‘frmProperty_Pre_RightClick_2013’. frmProperty_Pre_RightClick_2013 is the popup menu.
The form works the same as the original Access 2003 form with one annoying exception. The exception is: Hovering the mouse over any record on the screen and right clicking does not change the current record. It does pop up the right click menu but whatever operation is selected is executed on whichever record happens to be current on the form. To change the current record I have to first click in the record I want to be current, then right click. I looked thru the options and properties on the old form and new form but I don’t see any differences.
How can I get the new Access 2013 screen to work like the old Access 2003 screen. Meaning that whichever record the cursor is hovering over when the right click is pressed becomes the current record?