Duane,

I'll try that.
Did you check out that thread? I have no familiarity with forms as datasheets,
which is why I was trying to avoid using them. Jesper said he had a workable
solution and Paul Overway apparently concurred. But I can't tell what "it" is
in his statement, "The first time it runs I create a crosstab query ..." and
I have no idea how he set up his subform.

Bill

Duane Hookom wrote:
I would use code to set the parameter values in the sql like:
strSQL = strSQL & "TRANSFORM ..." & vbCrLf
strSQL = strSQL & "SELECT ..." & vbCrLf
strSQL = strSQL & "FROM tblSwapParameters AS Params, Params2 " & vbCrLf
strSQL = strSQL & "WHERE swapid=" & [Forms]![frmSwaps]![SwapID] & vbCrLf
strSQL = strSQL & " And somefield=" & [Forms]![frmSwaps]![Conf95] & vbCrLf
strSQL = strSQL & " GROUP BY swapid, ..." & vbCrLf
strSQL = strSQL & " PIVOT CalcMonth;"

Duane,

[quoted text clipped - 52 lines]

Bill

--
Bill Reed

"If you can't laugh at yoursel, laugh at somebody else"

Message posted via http://www.accessmonster.com