If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Re: Help with data report (RUSS - A QUESTION)

>
>
>Russ, forgive me but I can not get your code to work. I am sure I am doing
something wrong. I assume that in the 'With rptMyReport.Sections...' line,
I should sub. my data report name for the 'rptMyReport'? In addition the
'lbl.Caption = frmMyForm.CompanyName' I should sub. my form name for the
'frmMyForm'? Where can I find some good information on the data report?
I have several 'how to' books which touch on it a little, but nothing that
covers it in depth.

Re: Help with data report (RUSS - A QUESTION)

"shannan" <shannonl9853@home.com> wrote:
>
>>
>>
>>Russ, forgive me but I can not get your code to work. I am sure I am doing
>something wrong. I assume that in the 'With rptMyReport.Sections...' line,
>I should sub. my data report name for the 'rptMyReport'? In addition the
>'lbl.Caption = frmMyForm.CompanyName' I should sub. my form name for the
>'frmMyForm'? Where can I find some good information on the data report?
> I have several 'how to' books which touch on it a little, but nothing that
>covers it in depth.
>
>Thanks for your help.
>
>Shannan
>

Sorry Shannan. Yes, you will need to substitute the name of your report
for rptMyReport and the name of your form for frmMyForm. You will also need
to substitute the name of the label on your report for lblCompanyName on
line 'Set lbl = .Controls("lblCompanyName")'. After that, the code should
work. If you still have problems getting it to run, try to post a snippet
of the code that is not working so we can take a look it.