Right click menu

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
 
A

Albert D. Kallal

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

A combo box does exactly what you ask for...
 
J

John

Space is short in the datasheet view and also combos are slightly
distracting when field widths are small.

Thanks

Regards
 
A

Albert D. Kallal

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
 
Top