Subreport/Groups keep asking for prompts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am building an invoice report. There are three subreports which are the
different services (and therefore layouts) that someone may be invoiced for.
This is the first time I've tried to use sub-reports and I'm not much of a VB
whiz. So please forgive if anything I do is fundamentally flawed.

The three sub-reports all load fine and shrink/grow like I wanted them to.
But I get prompted for a value for each of them. The 3 queries that those
subreports are based on get their criteria from a control on a subform.

Is there a way I can do this better? Or failing that a way I can supress the
error prompts?

Thanks

Nick
 
What value are you prompted for? If you get the criteria
correctly from a control on a subform, there is no reason
why you should be prompted at all.

(david)
 
It's weird. I think I'm getting prompted for the table names that the querys
are running against. Any ideas?

I figure I've set something up wrong
 
Are you being prompted by the queries? If you separate
the queries from the reports, do they still prompt you?

Are you being prompted by a control? If you wipe all the
controls off the subreports, are you still prompted?

Are you being prompted by Sorting & Grouping? If you
look at the Sorting & Grouping, is there an old value
that is no longer valid?

Are you being prompted by the Subreport Master/Slave
properties?

(david)
 
Back
Top