I would like to have a Caret Category from view in my form, and I do something like this:
Dim category As Variant
category = Source.CaretCategory
Messagebox category
and it is OK, but what should I do if in my view are three columns and first and second columns make groups and I want to have the name of the group of first column?
For example:
in first column called first I have values:
white
black
green
and there are three groups (for each colour).
In second column I have another groups, for example:
big
little
(and for each group of colour I have two groups (big, little)). And in third column I have something of specific category. Things white and big, white and little, green and big etc. And now when I am clicking on one thing I would like to have colour of this. How can I do this?
thanks a lot
Krzysiek