J
Joanne
Hello, I am trying to have a report run from a form. The user enters
information into the form and then, based on that information a report will
run when the user clicks a command button. I am testing with some hard-coded
parameters and have the following:
SQL = "SELECT tblPatentCaseInformation.Citation,
tblPatentCaseInformation.CaseName,tblPatentCaseInformation.[Parties-Appellant]
from tblPatentCaseInformation WHERE
(((tblPatentCaseInformation.[Parties-Appellant])=[Philip Roth]))"
The report seems to run, but it keeps saying that it is printing, and also
it is treating it as a parameter query and asking me for the parameter for
"philip roth". Please help. I just don't see what I'm doing wrong.
information into the form and then, based on that information a report will
run when the user clicks a command button. I am testing with some hard-coded
parameters and have the following:
SQL = "SELECT tblPatentCaseInformation.Citation,
tblPatentCaseInformation.CaseName,tblPatentCaseInformation.[Parties-Appellant]
from tblPatentCaseInformation WHERE
(((tblPatentCaseInformation.[Parties-Appellant])=[Philip Roth]))"
The report seems to run, but it keeps saying that it is printing, and also
it is treating it as a parameter query and asking me for the parameter for
"philip roth". Please help. I just don't see what I'm doing wrong.