I see now, thanks. The value is not going to be in the list, but the controlsource is still updated.
Exactly. I developed the class for a client who occassionally had a need to type in values "on the fly" that were not in the standard lookup table. He did not want the "on the fly" values to be added to the lookup table because they were only required once in a blue moon and he did not want to clutter up the standard values by adding the non-standard ones.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only