G
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?
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?