RE: Store Added Value List Items

your combo box is set to 'Value List' and that's not going to change from
station to station.

you need to store these values in a table and then set the source type to
'Table/Query' and set it to that table.

THEN on the 'Not In list' event you need to add that value to that
underlying table.

NOW with all that said, depending on the data and business rules and
everything else. What I do when I want a combo box to show viable values to
select for a certain field I create a totals query with that field and it
grouped. SO I get a list of all the items ever entered in that field without
duplicates (You'll also be able to see who is entering in bad values i.e.
names similar but not exact.) This list always stays current because it's
based off the data entered in that field.
--
~Your Friend Chris
http://myvbastuff.blogspot.com/
thinking out loud


"Eka1618" wrote:

Hello,

I have created a text field (CUSTOMERS) which has its Display Control
Property set to a Combo Box and The Row Source Type set to Value List.

When users in my database want to add a new customer they select the button
to add more values to the list. (I have the Limit To List Propery set to no).

It seems that if the users try to add values to the list, those added values
are only staying on their PC or something. The database is split, so I guess
I do not understand the purpose of having the Add to List button for a combo
box if it will not add values across the board.

Can anyone explain to me why the values will not stay in the list for every
user? This list is not generating from another table or anything, its just a
random set of choices for the user to store for this particular field in the
table.

Thank You!
--
~Erica~
.