Wierd Parameter Keeps Popping up (1 Viewer)

I have a report that prints cheques, it works great. It is based on a 3 table query.

It displays the Cheque, and payment details after.

I then added a subreport, to show how many passengers the cheque is paying for, this is done by associating the invoice ID in the invoice table to the Invoice ID in the passengers table.

It picks up the data from the open form perfectly, but it keeps prompting me for tblInvoice as a parameter before it opens. I thought it was an error in the SQL but I used the wizard and cant figure it out. Why is prompting me for the table name tblInvoice?

Sincerely,
Jordan

I cant figure out why whenever I run the report, when including a subreport it prompts me for a value. The Value its asking for is the tblInvoice which is the name of my invoice table.

I think the wizard is the problem but im not sure?

Anyone else run into these problems?

Jordan,

The query that feeds your subreport has an unresolved
source field. That's why it keeps asking you for the
parameter.

The only suggestion is get your subreport in design view
and validate each column in the query.

Wayne

Thank you so much WayneRyan.

Looking into it now.

Sincerely,
Jordan