Returning Values from a Pivot Table Form

[Klatuu]

I have a poorly designed database (kindest way to put it)
I cannot change it now, so no suggestions for changes can be considered.
I have a form for entering master records in another table.
One of the fields in the table is RateType.
The Rate Table is constructed as:
RateType - Resouce - Rate
0 SEL 96.00
0 SOL 100.00
0 SUP 85.00
0 ODCB 1.05
1 SEL 100.00
1 ODCB 1.05
2 SUP 85.00
2 SEL 104.00
2 ODCB 1.05

The user will need to select a Rate Type where the rate for each resource
matches the rate that will be charged for the master record. I would like to
present it as:

RateType SEL SOL SUP ODCB
0 96.00 100.00 85.00 1.05
1 100.00 1.05
2 104.00 85.00 1.05

Creating a Pivot Table form seemed to be the easiest way to do this. I
would have the user click a button that would present the pivot table, select
the row with the desired values, and return it to the form she is working in.

The problem is, I can't figure out how to return any values from the
selected row. If I use Me.Resource, it always returns the value of the first
row in the underlying table regardless of which row I select on the Pivot
Table form.
Is a Pivot Table form basically read only, or is there a different property
or method I should be using?