[AccessD] Assign a control source for the control on Reportbasedon dynamic crosstab query

Hi,
Ken's solution(code in the Open event of the report) was good yesterday, but 
today I do some modification in code for report header and he's solution 
doesn't work yet. After a couple of hours of pulling my hair out I'll kindly 
ask if somebody want my demo to check my 15-20 of lines of VBA code...
Thanks in advance,
    Ervin
----- Original Message ----- 
From: "Ken Ismert" <KIsmert at TexasSystems.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Friday, April 07, 2006 6:39 PM
Subject: Re: [AccessD] Assign a control source for the control on 
Reportbasedon dynamic crosstab query


>
> Ervin,
>
> How about something like:
>
>    txtBox1.ControlSource =
> db.QueryDefs("qryCroRealPrPred").Fields(1).Name
>
> -Ken
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com