QBF Queries and Reports

  • Thread starter Thread starter Lena
  • Start date Start date
L

Lena

I've created a query by form with a combo box, which works
well with query-like data output. I need the output to be
in report format however when I run the report from the
query I get a blank. Any suggestions?
 
There are two techniques you can use to get data to the report.

1. Populate a temp table with the query results, and base the report on it.
This means that your search form will use an Append query instead of a
select.

or

2. Using the OpenReport method, you can supply the Where parameter with the
selected criteria. Have the report based on an appropriate table or query,
which can use the supplied criteria.

i.e. Docmd.OpenReport "rptName", Where := "EmployeeID = " & cboEmpID


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top