Recent content by Ms Kathy

Upon further thought, I'm going to move in another direction. I don't feel right bothering you all with this. No need to dig any further. Thank you kindly for what you've done to date!

Yet your report differs from the original - your report works (by not cutting off at the bottom of the first page and continuing onto the next page). I want to use it, but I can't unless I can duplicate what you did (onto my original). I hate to belabor this - but if you can remember what you...

Still trying to narrow down where the changes were made. Have discovered that it must be in the main report, as I copied over each of the three reports (one main and two subreports) individually and the change occurred in the main report. However, still haven't found what it is . . . Gosh, I...

There is a page break on the main report R_Recipes located after the subreports in the detail section; and a page break on sub report R_Recipes_Checks subreport on the report footer; there is no page break on the other sub report. These page breaks are not new (they are on the original db)...

This works - as in when there are many ingredient entries the list continues on the next page; and the QC Checks continue to hide if other than "major"; and the report groups on the type (i.e. Major). I have searched the report and subreports properties and underlying queries (comparing your...

I posted here previously on another matter (hiding a subreport, if) and that was resolved. The issue I now have is on the same report (but a different issue). The QCcheck subreport is cut off the main report when the ingredient list is too long. I've tried so many different combinations of Can...

Oh my gosh!!! It does work!!!! I don't know what I did wrong before, but I am thankful that it's working now. Thank you (to you both)!

I made a copy of the db, stripping it down. I think everything you need is included. (By the way, I did try doing what arnelgp suggested, but the subreport was not visible on ALL reports - even "major"). Thank you for your help!

Reading over your previous message, please note that recipes have multiple ingredients and those ingredients have one sub type (i.e. "major" or other) and not more than one.

Here's the report; I'll get the other stuff you need too.

Yes, I will do that. I need to enter some dummy info first. These need to be jpg or pdf?

Doing this is making the subreport not visible even if "major" type. I think I have to go back to the drawing board on this one. The main report has a text field to show the type from the ingredient subreport and I'm trying to hide the other subreport based on this. Anyway, I don't even know...

Thank you for the response, unfortunately I can't do that because I have check off boxes and some other formatting on the sub report.

I placed this on the Main report, On Print event; but get an error ("Compile error") Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) Me.child.[Report]![R_Recipes_Checks subreport].Visible = Me.[txtRecipeMix] = "major" End Sub