My ColorSet building form/subform now works beautifully, thanks to the
help that I've gotten from people in this group.
The working form displays the parent ColorSet record with the
child records displayed in the subform below it.
ParentTable fields: ColorsetName Classsize [& a few irrelevant fields]
ChildTable fields: ColorsetName ColorSequenceNumber RedVal GreenVal BlueVal
I've now been asked to allow the user to generate a new ColorSet from
an existing one: the new ColorSet record will have associated to it a
subset of the old ColorSet's colors [which subset might be all of the
old ones], and possibly newly defined additional colors.
I am not at a loss as to how to allow the user to define the new
ColorSet parent and child records, but I have a feeling that what I'm
thinking of is more like coding in C or even Perl than a natural VBA
solution. I'm thinking in terms of a command button for
requesting the new ColorSet, textboxes for its name etc, a checkbox with
the sequence numbers of the existing ColorSet from which user chooses
those to be included in the new one, and lots of code to get the
information into the new records. I haven't yet thought about where
to define any new colors.
I'd appreciate it if someone could sketch for me an approach that
an experienced Access programmer would use to implement this
thanks, --thelma