I have a combo box on a form that I populate with a list of items from
a lookup table. Access 2007 created a form for me to enter those
values. When I right click on the combo box I can select "Edit List
Items..." and it will take me to that form. The users that will be
using it I want to have access to this, but if I disallow full menus
from the "Access Options" page, then it disables this feature as
well. Is there any clean way to do this? Or do I have to kludge it
together?

create your own data-entry form for the lookup values, then set it to open
on right-click of the combo-box.


"LeppyR64" <(E-Mail Removed)> wrote in message
news:1ebf29e6-9e16-40b0-a1fa-(E-Mail Removed)...
>I have a combo box on a form that I populate with a list of items from
> a lookup table. Access 2007 created a form for me to enter those
> values. When I right click on the combo box I can select "Edit List
> Items..." and it will take me to that form. The users that will be
> using it I want to have access to this, but if I disallow full menus
> from the "Access Options" page, then it disables this feature as
> well. Is there any clean way to do this? Or do I have to kludge it
> together?