Query Box...

  • Thread starter Thread starter stephendeloach via AccessMonster.com
  • Start date Start date
S

stephendeloach via AccessMonster.com

I have a Report named Drilling Invoice. I want to have a query box that comes
up when I click on the report and has a place for "BillTo:" , "WellName:" ,
and "Invoice#". Now I have the paramform box and works fine but I want it to
be on one popup box... Does this make sense? Thanks

Stephen
 
stephendeloach via AccessMonster.com said:
I have a Report named Drilling Invoice. I want to have a query box that
comes
up when I click on the report and has a place for "BillTo:" ,
"WellName:" ,
and "Invoice#". Now I have the paramform box and works fine but I want it
to
be on one popup box... Does this make sense? Thanks

Stephen
Click to expand...

You'll need to create your own form for this, and then open the report from
that form. Use the DoCmd.OpenReport method, and pass your values in the
WhereCondition parameter of the OpenReport call (the format will be the same
as a WHERE clause, minus the word WHERE). The report should be based on the
full query, without any conditions; the WhereCondition parameter will take
care of the rest.

Carl Rapson
 
Back
Top