Search results

I can't get this to work? Any ideas?

I am having this same problem, what does he mean about the subreport not being correctly linked to the main report?? I have seen this topic posted elsewhere and there does not seem to be a resolution that works? People have suggested the Nz function but that doesn't fix this either. Any ideas?

What function can I use to get the sunform to return Null if it has no records?

Thanks for your reply. I am already using that Nz statement and it it not working.

I hope this is a no-brainer. I have several fields from 2 subforms that are added together to display totals on the main form. When 1 subform returns no values, the total calculation displays #Error on the main form. Is there a way to get the fields on the subforms to have a default value of...

Open the form/report in design view. You should have a toolbar that has icons on it for the different controls you can add to the form,just click on what you want and draw it on the form. If you have the wizard button clicked(looks like a wand) it will walk you through the setup of the control...

I am using a query to populate a continuous form, in the form footer I am adding fields that total the results of the query. This works fine for a while then I will start getting #Error in the total fields only. The form displays rows of invoice numbers and cash, I total the cash with...

Doug, Is a pop-up the same a showing a second form with the details, or does it hover right next to the main form?

Thanks for your help. I can get the method you suggested to work just fine. What they want me to produce for them is a drill-down report, without using a pop-up, they want it all on the same page so they can "expand" a couple of lines to compare the details, similar to what a datasheet does when...

I am using a continuous form that displays lines of summary info for each invoice number, when you click on the invoice number the hidden details fields appear for each invoice by using the Click event to change the fields to visible. How can I get the fields for just one of the invoice numbers...