Right click menu

message from John on 14 May 2004
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
 
Albert D. Kallal replied to John on 13 May 2004
Any particular reason why you don't use a combo box?

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.attcanada.net/~kallal.msn
 
John replied to Albert D. Kallal on 14 May 2004
Space is short in the datasheet view and also combos are slightly
distracting when field widths are small.

Thanks

Regards

"Albert D. Kallal" <PleaseNOOOsPAMMkallal@msn.com> wrote in message
news:OQVLpEVOEHA.1160@TK2MSFTNGP09.phx.gbl...
 
Albert D. Kallal replied to John on 14 May 2004
That is fair answer.

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
 

Archived message: Right click menu (MS Access Forms)