Pop-up menu - event procedure

[ROY A. DAY]

I have established a “Query†file in Microsoft ACCESS with the following SQL
syntax:

Select sum(pricepack)
From orders
Where Lastn = ‘smith’

The aforesaid “Query†file is linked to “FORM†view file.

If I wanted the “user†to use a “pop-up†menu in the FORM VIEW file to place
a “new†last name in the aforesaid SQL syntax “linked†“QUERY†file, what
would be the “keystroke-to-keystroke†and “cursor-to-cursor†syntax for an
“event procedure†in the “FORM†view for a “pop-up†menu so a user could
place a new last name in the aforesaid SQL syntax? (NOTE: If you right click
the properties in FORM VIEW, and then access the “event†menu, it appears you
should be able to select an event procedure for a “pop-up†menu.) What would
be the associated code for the expression for the aforesaid event procedure?
Please provide a keystroke-to-keystroke syntax procedure for the aforesaid
event procedure code.

 

[Albert D.Kallal]

There is no event in the form for the right click (shortcut) menu

However, what you normally do is create your own custom right click
menu...and just like a button...you have a "on-Acton" event.

So, those custom menus, be they a menu bar you create, or a right click menu
simply can call your code of choice....

So, build a custom right click short menu...and have it call your code of
choice....

The above of course assumes you are familiar with building menus in
ms-access. (they don't require any code to build...but they are not so
intuitive to build the first time).