Sub Report not Printing.

[Hoopster]

This has to be someting simple I'm missing but when I send my report to the
printer, all I get is the main report printed and not the sub_report. Both
show up in the print preview screen.

 

[Duane Hookom]

Normally this is because a form with the criteria is closed somewhere in an
event of the report or code calling the report.

 

[Hoopster]

Duane,

Thanks for the response. I solved this problem after reading your
response to a post I placed on Google. My problem wasn't a Form being closed
but that I was trying to use the wrong Control in my Code. When I changed my
Code, the Sub-Report started working. If it hadn't been for your responce on
Google though, i wouldn't found even that. Thanks again.
I do have a problem though but not sure weather or not you want me to
post it on this thread or not. It has to do with the Concatenate example you
have out on the Web. Can't remember the adress but i downloaded it and can't
get it to work for me. I've been struggling with it now for about 3 or 4
day's. If you want me to start another tread, I'll add my code to it when I
make the Post.

 

[Duane Hookom]

You should really start a new thread with Concatenate in the subject
somewhere and probably in the queries (or other). Before you post, keep in
mind that most of my examples used a numeric field to link the parent and
child records. If you have a text field, you need to use something like:
Concatenate("SELECT [FirstName] FROM [tblNames] WHERE [LastName]=""" &
[LastName] & """")

If this doesn't work, start a thread with your table structure and attempted
concatenate expression.