Combo Box / NotInList and other things...

C

cognoscento

I have a series of cascading combo boxes in a subform I'm presently
working on and could use a touch of guidance.

I want to create a NotInList event for each combo box that will write
it to the underlying table, after a suitably severe warning and
confirmation dialogue. Something like the code on
http://www.fontstuff.com/access/acctut20.htm#fullcode is what I'm
looking for.

Problem is that these cascading combo boxes aren't based on a separate
table from the one the subform is based on; they're grabbing their
options (using a SELECT DISTINCT in the rowsource) from the other
records already present. So the above script seems to require
modification... or a different method entirely is required to solve
this problem.

And I'm not a coder. So I don't know where to start.

In the end, I cannot change the data structure, only for the form and
its code. This functionality I'm trying to create is important for
me... any advice?

(I can provide more detail into the structure of the relevant parts of
the database and the code written so far, if needed...)

C.
 
Top