We help IT Professionals succeed at work.

Custom Popup Menu in Access

EMCIT
EMCIT asked
on
681 Views
Last Modified: 2012-06-27
I have a form with two list boxes. One box lists positions (bartender, floor, bus, door, etc.) and the other lists employees. Right now I click the positions box and then the employee box and it puts that employee in the selected position. What I want to develop is a popup menu that appears when I right click a record in the employee's box that contains the "positions". When a position is selected I want the code to run that executes the update query. Any help is greatly appreciated.
Comment
Watch Question

Yes, see the custom popup menu section on this page..http://www.jamiessoftware.tk/articles/menubars.html

Author

Commented:
I Googled this page earlier. It doesn't address what I want. I can get it to execute a macro or load a form, table, query, report, etc. but I need the popup to display a list of positions that, when clicked, runs the update query.

Commented:
Tools-Customize

Create a menu using macros to perform the designated task. Go to properties and allow shortcut menu and set to the menu you created.

Author

Commented:
<<Create a menu using macros to perform the designated task>>
How will this create a list of positions that will appear in the popup?
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
I have two tables. Employees and Positions. Right now I have each table populating a list box so that I click a position in box one and then click an employee in box two and it assigns that employee to that position through an update query. I want to skip the first box. When you right-click a name in the employees box I want a popup menu that contains the list of positions. When you left click a position it stores the position and fires the update query. Same results, different process. I can create a popup that will open a form or report or table, query, etc. but I can't get the positions list to populate the popup.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.