Pop-up menu - event procedure

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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).
 
Back
Top