Previous Thread

8/7/2006 5:46:24 AM    DoCmd.OpenReport with Where condition - how to show Where value on report
Hi, I'm opening a report from code and I'm using the Where parameter of 
 
the OpenReport method. 
 
Is there a way I can reference all or part of that where condition in 
 
the report itself and print it in the Report or Page Header? 
 
thanks, 
 
Bruce



8/7/2006 11:21:03 AM    Re: DoCmd.OpenReport with Where condition - how to show Where value on report
Hi, thanks for writing back.  I open the report from a different form, 
 
will the report know about variables from the calling form? 
 
thanks, 
 
Bruce 
 
PBsoft wrote:

8/7/2006 1:46:19 PM    Re: DoCmd.OpenReport with Where condition - how to show Where value on report
Seen that you are opening the report from code, you can put the Where condition 
 
into a variable and use either in the OpenReport statement or elsewhere. 
 
-- 
 
PBsoft di Gabriele Bertolucci 
 
www.pbsoft.it 
 
skype: pbsoftsolution

8/7/2006 8:43:15 PM    Re: DoCmd.OpenReport with Where condition - how to show Where value on report
Hello brucek, 
 
You wrote in conference microsoft.public.access.adp.sqlserver  on 7 Aug 2006 
 
05:46:24 -0700: 
 
b> Hi, I'm opening a report from code and I'm using the Where parameter of 
 
b> the OpenReport method. 
 
b> Is there a way I can reference all or part of that where condition in 
 
b> the report itself and print it in the Report or Page Header? 
 
Yes, you will find it in the property ServerFilter. Put textbox with 
 
controlsource   =serverfilter . 
 
Vadim Rapp