How to use PivotTable as a source of selection?
 

The original question is as follows:
My access database has 100 fields, I have to output 4 of them, but unique
into a excel sheet combobox for free picking up. User can start from any of
the 4 combobox, and the rest three will update and refresh according to the
one picked, once the 2nd one picked, all the rest 2 will updated, and etc. In
this case, user wouldn't make the combination which does not exist in the
database.

I am using VBA as write code behind. But somehow, I cannot make it. Thus, I
am thinking of using PIVOT Table.
Now, I can use VBA code to generate PIVOT table from Access to Excel sheet,
then use can make the combination freely according to there preferance. Then
my question is how to get the last record picked by user as input of other
function/module?
For example, the one user picked is :
Employee : Jane, Age: 30, school: Stanford,
How to getPIVIOTDTA of: Jane, 30, Stanford.
Thank you so much in advance.

How to use PivotTable as a source of selection?
 

It was done. As the selected item will always stay in the fixed cell. Get it
from there. Thanks.

"NiNi" wrote:

The original question is as follows:
My access database has 100 fields, I have to output 4 of them, but unique
into a excel sheet combobox for free picking up. User can start from any of
the 4 combobox, and the rest three will update and refresh according to the
one picked, once the 2nd one picked, all the rest 2 will updated, and etc. In
this case, user wouldn't make the combination which does not exist in the
database.

I am using VBA as write code behind. But somehow, I cannot make it. Thus, I
am thinking of using PIVOT Table.
Now, I can use VBA code to generate PIVOT table from Access to Excel sheet,
then use can make the combination freely according to there preferance. Then
my question is how to get the last record picked by user as input of other
function/module?
For example, the one user picked is :
Employee : Jane, Age: 30, school: Stanford,
How to getPIVIOTDTA of: Jane, 30, Stanford.
Thank you so much in advance.