Right click menu

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

When a user is editing a text field, I would like to allow the user to right
click and view a pop up menu of values taken from a table and when a value
is selected from the popup, the text field is filled with the selected
value. How do I create the pop up menu from a table and how do I get the
selected value from popup into the field?

Thanks

Regards
 
Any particular reason why you don't use a combo box?

A combo box does exactly what you ask for...
 
Space is short in the datasheet view and also combos are slightly
distracting when field widths are small.

Thanks

Regards
 
That is fair answer.

Hum.....I would then consider setting up a popup form that gets launched
when you right click....

You *could* create a right click menu..but then again..that right click menu
would only be used to launch the form that pops up a list to select
from.....so, just create a nice pop up form that displays a nice list......


You can use the on-mouse down event to capture the right click on a
control...

If button = acRightButton Then

DoCmd.OpenForm "youcool pop form"

End Sub
 
Back
Top