Hi Jeff
No doubt there will be an obvious reason once the dust settles. :-)
In the mean time, is there any chance Access could misunderstand the data
type of any of these fields? Particularly:
- calculated fields may need to be typecast;
- query parameters may need to be declared (esp if applied to calculated
fields, or if reading a value from a control on a form);
- text boxes may need their Format property set if unbound, bound to an
expression, assigned programmatically, or bound to a calculated field.
Do the *controls* have the same name as the fields? If not, are you using
the control names in LinkMasterFields/LinkChildFields?
How are you limiting the date range for the subreport?
The subreport CanGrow?
You've probably tried a compact'n'repair (just in case there's a bad index.)
No doubt you already have the Name AutoCorrupt boxes unchecked (Tools |
Options | General.)
If none of that goes anywhere, what happens if you create a query based on
the main report's query joined to the subreport's query on OrderInvoiceNo
and LineNo?
BTW, there's a rumour that dark chocolate is supposed to be good for us?
:-)
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Jeff" <je************@asken.com.au> wrote in message
news:43***********************@per-qv1-newsreader-01.iinet.net.au...
Damn this is frustrating. I have used subreports for years and never had
this problem. I have used these things more times than I can remember.
Never have I had this problem. Arrrgggghhhhhhhhhhhhhhhhhhhhhh.....etc and
ahhh
This should be simple, but... This is a report for a sales order. Parent
report actually shows the header and detail, detail is not in the
subreport. In the subreport is a breakup of committed product by UseBy
date.
Master and Child link fields are both 'OrderInvoiceNo;LineNo'. There are
records to show for the order the report is generated on.
The fields do exist in both the parent and sub reports.
If I remove the link fields the report shows heaps of records, as
expected, including the ones that should show for each detail. Add just
the OrderInvoiceNo and nothing shows. Add anything in the link fields and
nothing shows.
Why? Is it because it is Monday? Or maybe because I was having a good day?
Or am I just missing something so obvious here that it isn't?
And yes, I have restarted Access, which usually fixes illogical problems.
And gone and had some comfort food - snakes. Haven't got to the chocolate
yet. Cholesterol is too high for pizza. Chocolate doesn't count.
Jeff Pritchard
________________
Asken Research Pty. Ltd.
Access Database Developers (still)
www.asken.com.au