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
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