Finicky filter in Access 2000

[Hilary Ostrov]

I'm trying to accomplish the fairly simple task of being able to view
one of two reports from their respective command buttons on the same
form.

The filter is exactly the same for both (as is the query on which the
two reports are based) - it's also fairly simple:
"InvoiceNo=Forms!MyForm!InvoiceNo"

It works fine for Report1, but everytime I want to view Report2, I'm
prompted to enter the Parameter Value "Forms!MyForm!InvoiceNo". And
when I feed it the Invoice No, Report2 appears as expected. So I can't
figure out what I might be doing wrong.

If the filter didn't work for either report, I could understand (sort
of ... it's not as though the InvoiceNo isn't sitting right on the
form)!

Any suggestions would be most appreciated.

hro
hro

 

[SA]

hro:

If you have a sub-report, check to see if the link master and link child
field are set up so that the parameter supplied from the main report is sent
to the sub report.

 

[Treebeard]

I'm trying to accomplish the fairly simple task of being able to view
one of two reports from their respective command buttons on the same
form.

The filter is exactly the same for both (as is the query on which the
two reports are based) - it's also fairly simple:
"InvoiceNo=Forms!MyForm!InvoiceNo"

How are you passing the filter to the report?

Are you embedding the filter in the query, or passing it in with the open
report method?

 

[Allen Browne]

Try this as the filter:
"InvoiceNo = " & Forms!MyForm!InvoiceNo"