How do I activate a record using right-click?

[Hirsute]

Simple question for MS Access 2003 (using VBA)...

I have "continuous" form (e.g. showing many records on a single form window). When I simply click (primary click) on one of those records it becomes the active record. When I right-click (secondary click) I have a short-cut menu that pops up. All of that works fine.

I want to combine those two steps into one (like most Windows Apps). Specifically when I right-click I want the record that I am right-clicking on to become the active record THEN I want the short-cut menu to pop up (so it commands will pertain to the newly right-clicked record).

Any help on how to do this? How can I find out what record I am right-clicking on in a continuous forms window?

[Rabbit]

Simple answer is you can't do this. Access doesn't have a right-click event nor does it have an option, that I know of, to have it select the record on right-click.

[Rabbit]

Resuscribing .

[ADezii]

Simple question for MS Access 2003 (using VBA)...

I have "continuous" form (e.g. showing many records on a single form window). When I simply click (primary click) on one of those records it becomes the active record. When I right-click (secondary click) I have a short-cut menu that pops up. All of that works fine.

I want to combine those two steps into one (like most Windows Apps). Specifically when I right-click I want the record that I am right-clicking on to become the active record THEN I want the short-cut menu to pop up (so it commands will pertain to the newly right-clicked record).

Any help on how to do this? How can I find out what record I am right-clicking on in a continuous forms window?

I'm not exactly sure if this is what you are looking for, but in a Continuous Form, if you Right-Click on any Field contained within the Form, you can Select that specific Record and should also be able to bring up the associated Short-Cut Menu for the Record. Try placing the following code in the MouseDown() Event of all Fields in the Continuous Form. Right Clicking on the Detail Section does not have the same affect, unless the Record has been previously selected. Let me know how you make out.

Private Sub LastName_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
  If Button = acRightButton Then
    DoCmd.RunCommand acCmdSelectRecord
    'Short-Cut Menu will appear on its own
  End If
End Sub