Ervin Brindza
viner at EUnet.yu
Fri Apr 7 01:34:26 CDT 2006
<Cross posted AccessD Access-L > Hi, I have a report which have crosstab query with dynamic column names for recordsource. So I have to assign the control source for the text boxes on the fly. Something like: Dim rst As Recordset Set db = CurrentDb Set rst = db.OpenRecordset("SELECT * FROM qryCroRealPrPred") Me.txtBox1 = "=" & db.QueryDefs("qryCroRealPrPred").Fields(1).Name & ")" Where should I put these lines? Or how to recalculate(evaluate) these text boxes(have no succeed with Eval function), because if I put these lines in the Detail Format/Print the text boxes contains only the field names(strings) not the values of the fields(numbers). Many TIA's Ervin