Subreport link not working

[fiep]

Hi,

I have a reports where the boxids in the following format:
SHP_090604_14:42:30

In the subreport I want to show all articles in the box and the are identified with the same boxid:
SHP_090604_14:42:30

I have linked the parent and child reports with the boxid column.

However when I open the report the child reports does not only show the articles in the selected box. I also shows the articles in boxes that start with the same string like:
SHP_090604_14:47:08
SHP_090604_14:51:23

Is this a problem with access? Does it only look for the first ten charachter or am I doing something wrong here?

Thanks in advance

 

[dhookom]

The link master/child properties of the subreport should look for exact matches only. There should be no limit on the number of characters (under 255).

Duane
MS Access MVP
Find out how to get great answers faq219-2884.