Report oddity

[gweasel]

I'm banging my head over here. I've got quite a few reports set up in
an almost identical fashion as the one I'm working with right now, but
this one is acting very odd.

I've got a form that gathers information to create a Fax Cover Sheet
from. It collects information from an existing table "Clients" for
[ClientName], [ClientFax], [ClientContact] and then has an unbound
combo box that collects an employee's name using a record source
"Tbl_Employees" with only 2 fields from the table being referenced
(EmployeeID and EmployeeName).

The problem is that when I click the button to open the report, I get
17 pages instead of 1. All 17 pages are identical. The only
significance to the number "17" that I can see is that there are a
total of 17 employees in the Employee Table. But, as I said, the fax
cover sheets are all identical, showing only the name of that was
selected from the combo box on the form.

Any idea what I'm missing here?

 

[Marshall Barton]

I'm banging my head over here. I've got quite a few reports set up in
an almost identical fashion as the one I'm working with right now, but
this one is acting very odd.

I've got a form that gathers information to create a Fax Cover Sheet
from. It collects information from an existing table "Clients" for
[ClientName], [ClientFax], [ClientContact] and then has an unbound
combo box that collects an employee's name using a record source
"Tbl_Employees" with only 2 fields from the table being referenced
(EmployeeID and EmployeeName).

The problem is that when I click the button to open the report, I get
17 pages instead of 1. All 17 pages are identical. The only
significance to the number "17" that I can see is that there are a
total of 17 employees in the Employee Table. But, as I said, the fax
cover sheets are all identical, showing only the name of that was
selected from the combo box on the form.

How are you opening the report?

What is the report's Record Source?

How is the report getting the information from the form?

 

[gweasel]

The report is largely unbound (well, most of the information comes
from unbound combo boxes on the form).
The only line in the report that has a source is the "Employee name"
which I explained in the first post.

The form has a command button that, after the information has been
entered (explained in original post)
opens up the report, filling it with information from the form.

I'm banging my head over here. I've got quite a few reports set up in
an almost identical fashion as the one I'm working with right now, but
this one is acting very odd.

I've got a form that gathers information to create a Fax Cover Sheet
from. It collects information from an existing table "Clients" for
[ClientName], [ClientFax], [ClientContact] and then has an unbound
combo box that collects an employee's name using a record source
"Tbl_Employees" with only 2 fields from the table being referenced
(EmployeeID and EmployeeName).

The problem is that when I click the button to open the report, I get
17 pages instead of 1. All 17 pages are identical. The only
significance to the number "17" that I can see is that there are a
total of 17 employees in the Employee Table. But, as I said, the fax
cover sheets are all identical, showing only the name of that was
selected from the combo box on the form.

How are you opening the report?

What is the report's Record Source?

How is the report getting the information from the form?

 

[Marshall Barton]

I guess you could make the report totally unbound and get
the employee name from the form too. Assuming the employee
combo box's BoundColumn is the ID field in the first column,
the reference in the report text box would be:
=cboEmployee.Column(1)

To keep the report bound to the table, you need to filter
for the specific employee. Change the open report line to
something like:
DoCmd.OpenReport ... , ... , , "EmployeeID=" & cboEmployee
--
Marsh
MVP [MS Access]

The report is largely unbound (well, most of the information comes
from unbound combo boxes on the form).
The only line in the report that has a source is the "Employee name"
which I explained in the first post.

The form has a command button that, after the information has been
entered (explained in original post)
opens up the report, filling it with information from the form.

I'm banging my head over here. I've got quite a few reports set up in
an almost identical fashion as the one I'm working with right now, but
this one is acting very odd.

I've got a form that gathers information to create a Fax Cover Sheet
from. It collects information from an existing table "Clients" for
[ClientName], [ClientFax], [ClientContact] and then has an unbound
combo box that collects an employee's name using a record source
"Tbl_Employees" with only 2 fields from the table being referenced
(EmployeeID and EmployeeName).

The problem is that when I click the button to open the report, I get
17 pages instead of 1. All 17 pages are identical. The only
significance to the number "17" that I can see is that there are a
total of 17 employees in the Employee Table. But, as I said, the fax
cover sheets are all identical, showing only the name of that was
selected from the combo box on the form.

How are you opening the report?

What is the report's Record Source?

How is the report getting the information from the form?