Access 2003

[tbeynon]

I need help getting the information selected from 3 combo boxes in a form to
pass to a query so that my report will populate with the data I requested in
the form. Information below.

Tables: tblProjects, tblCustomers, tblPunchItems
Relationships: one customer to many projects, one project to many punch items

Form: ParamForm with a command button to Preview Report.
Report: rptSpecificJobPunchlist

Query: In SQL View: SELECT tblProjects.ProjectName, tblProjects.Customer,
tblProjects.ISSProposalNumber, tblPunchItems.*
FROM (tblCustomers INNER JOIN tblProjects ON tblCustomers.Customer =
tblProjects.Customer) INNER JOIN tblPunchItems ON tblProjects.
ISSProposalNumber = tblPunchItems.ISSProposalNumber
WHERE (((tblProjects.ProjectName)=[forms]![ParamForm]![cboProjectName]) AND (
(tblProjects.Customer)=[forms]![ParamForm]![cboCustomer]) AND ((tblProjects.
ISSProposalNumber)=[forms]![ParamForm]![cboISSProposalNumber]));

When I click on the report (rptSpecificJobPunchlist) it opens up the
ParamForm where I can choose an existing Project Name, ISS Proposal Number
and Customer. Then, click the command button to preview the report.

However, when I go to preview the report I get nothing but the framework of
the report. No data.

I would be greatly appreciative if any assistance could be provided.

 

[KARL DEWEY]

What is the results when you make the selection of the 3 combo boxes and then
run the query directly without command button?

What is the report results when you run it without using making the
selection of the 3 combo boxes, enter data in response to prompts, and
without using the command button?

Why do you have tblCustomers in the query as I do not see it serving a
purpose except to eliminate data if the table is not populated?

 

[tbeynon via AccessMonster.com]

Karl,

I was able to figure it out. It happen to be that the form was the issue.
It did not know how to handle the long integer. With some help I was able to
include a parmater in the query that resolved it. Sorry for the lack of
details.

I do have another question though. I will post a new thread to get an answer

What is the results when you make the selection of the 3 combo boxes and then
run the query directly without command button?

What is the report results when you run it without using making the
selection of the 3 combo boxes, enter data in response to prompts, and
without using the command button?

Why do you have tblCustomers in the query as I do not see it serving a
purpose except to eliminate data if the table is not populated?

I need help getting the information selected from 3 combo boxes in a form to
pass to a query so that my report will populate with the data I requested in

[quoted text clipped - 23 lines]

I would be greatly appreciative if any assistance could be provided.