i have a trouble in inherit value list of access 2007

  • Thread starter Thread starter nancy
  • Start date Start date
N

nancy

i am new programmer and use access 2007 to do customed software. I have a
trouble with a combo box. i enable its properties of inherit value list and
Allow value list edit, which make user can add items in the list. But when i
changed the progam to be a .accdr , function above is disable, user can not
add new item in the value list , why ? what happened? i think it is
unreasonable, mybe something i did is wrong, maybe something i have to do.


thank you for help

it seems to be related to "allow full menus". i must offer user a .accdr ,
how can i do?
 
You can't edit objects like that (and save them) in runtime mode. Create a
table for the list and base the combo rowsource off of that instead of a
value list. Then you can update the table in runtime.
 
Um, I may be wrong but in 2007 this function just allows you to associate a
form with the combo box and add items to a table. Basically it provides the
same function that was in the old templates without code. I haven't tried
it when file is in accdr format but the drawbacks on Allen Browne's site
mean I'll just keep using the code I wrote to do it.

http://allenbrowne.com/ser-27.html

Set the List Items Edit Form property of the combo box.
Right-click to edit/add to the items to the combo's list.
 
The majority of MVP's agree with me. You should use a value list when the
list is not likely to need to change. If it needs to change then you should
use a table.
 
I agree with you also, but to the original question, is this feature
supposed to work in runtime? It would be handy for folks that need to add
an address to a lookup. No real information on this and some other new
features in 2007 help. Kind of like teasing the new users.
 
Back
Top