"Edit List Items" on runtime?

I have some database forms in Access 2007 set up so that when I use a
combo box control, a little button shows up at the bottom that says "Edit
List Items." When I click this, it opens up the form behind the combo box
and lets me add a new item.

When I give this form to my coworker using the Access 2007 Runtime though,
these Edit List Items buttons don't show up.

Is there a way I can make them visible on the runtime? Or an alternative
to let them add a new list item?

Thanks,
Joel

I think I have the same issue... when I type the new data into a combobox in the form view, if its not in the list already a box pops up and states "the text you entered isn't a item in the list" "Do you want to edit the items in the list?" Yes or No etc... If I say yes, it does let me add the item to the list and even set it as the default, This is in the full version of access, however in Runtime Version, it goes over the same as above and lets me enter item in the list but the next time I open the database it isn't retained in the list.

Is this what you are getting ? I found some thinks on the microsoft forum but they really never pointed anyone in a direction.

Have you made any progress?

thanks



Joel Parker wrote:

"Edit List Items" on runtime?
07-Aug-07

I have some database forms in Access 2007 set up so that when I use a
combo box control, a little button shows up at the bottom that says "Edit
List Items." When I click this, it opens up the form behind the combo box
and lets me add a new item.

When I give this form to my coworker using the Access 2007 Runtime though,
these Edit List Items buttons don't show up.

Is there a way I can make them visible on the runtime? Or an alternative
to let them add a new list item?

Thanks,
Joel

EggHeadCafe - Software Developer Portal of Choice
ASP.NET DropDown Menu Server Control
http://www.eggheadcafe.com/tutorials...-menu-ser.aspx

You can solve that problem, generically with this code:

http://www.datastrat.com/Code/NotInListCode.txt

and I have a demo for using it at:

http://www.accessmvp.com/Arvin/NotInListDemo.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Andrew Revelle wrote in message ...
I think I have the same issue... when I type the new data into a combobox
in the form view, if its not in the list already a box pops up and states
"the text you entered isn't a item in the list" "Do you want to edit the
items in the list?" Yes or No etc... If I say yes, it does let me add the
item to the list and even set it as the default, This is in the full
version of access, however in Runtime Version, it goes over the same as
above and lets me enter item in the list but the next time I open the
database it isn't retained in the list.

Is this what you are getting ? I found some thinks on the microsoft forum
but they really never pointed anyone in a direction.

Have you made any progress?

thanks



Joel Parker wrote:

"Edit List Items" on runtime?
07-Aug-07

I have some database forms in Access 2007 set up so that when I use a
combo box control, a little button shows up at the bottom that says "Edit
List Items." When I click this, it opens up the form behind the combo box
and lets me add a new item.

When I give this form to my coworker using the Access 2007 Runtime though,
these Edit List Items buttons don't show up.

Is there a way I can make them visible on the runtime? Or an alternative
to let them add a new list item?

Thanks,
Joel

EggHeadCafe - Software Developer Portal of Choice
ASP.NET DropDown Menu Server Control
http://www.eggheadcafe.com/tutorials...-menu-ser.aspx