F
FatherBob
I Know that there are several posts about this - but I seem to have got
myself into knot.
I have a Form/subform for Invoices and have a button at the bottom to print
the invoice. When the code runs it assigns an invoice number and writes it to
the Invoice Table - works fine! Next Step is to Print the Invoice - when the
code runs it prints an Invoice containing the MasterRecord then includes all
the Sub order records from other orders for the same customer?? I am
filtering on Order Number so this should not happen. I get an error message
telling me that the report I am referencing does not exist or is not open???
Strange as it runs and Prints - even though it's not what I want. I have
included the button code - can anyone see a syntax problem or perhaps
suggest a better way of doing this. I did try building a control source
string but had little joy with it. Any advice would be welcome.
Regards Bob.
myself into knot.
I have a Form/subform for Invoices and have a button at the bottom to print
the invoice. When the code runs it assigns an invoice number and writes it to
the Invoice Table - works fine! Next Step is to Print the Invoice - when the
code runs it prints an Invoice containing the MasterRecord then includes all
the Sub order records from other orders for the same customer?? I am
filtering on Order Number so this should not happen. I get an error message
telling me that the report I am referencing does not exist or is not open???
Strange as it runs and Prints - even though it's not what I want. I have
included the button code - can anyone see a syntax problem or perhaps
suggest a better way of doing this. I did try building a control source
string but had little joy with it. Any advice would be welcome.
Regards Bob.