Please help - Repost - Info not pulling forward!

[JNana]

I have three reports - Invoice, Packing List and Bill of Lading - based
upon my Customer
Orders subform, Order Details. 3 problems are occurring:

1. Information from only the first line is visible; i.e. If I have
more than one line item with information in the notes field, only the
information in the notes field for the first line item is
visible on my invoice, packing list and bill of lading.

a. The field for notes is marked, visible at all times, can grow,
can shrink. I have changed it to Can Grow - No and that does not make any
difference.

2. Some of the time, Customer "A"'s information from the first
line item is visible on these reports, while the next customer's information
from any of the lines does not appear. I can see no difference in the
customer information.

OR

3 This field does not contain any information from any of the lines.

a. The query that this is based on displays the information
correctly.

What do I need to be looking for? I don't see any reason why this is
happening?

Thanks in advance,
JNana

 

[strive4peace]

1. the subreport control needs to be CanGrow =Yes

2. instead of using criteria in the query to link records,
use the

LinkMasterFields
LinkChildFields

prpperties of the subreport control -- use control names,
not fieldnames


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*