Home > IT Answers > Database > creating reports with forms/subforms
Sunshine076
60 pts.
 creating reports with forms/subforms
Access 2000, Access forms, Microsoft Access, Microsoft Access forms, Microsoft Access subforms
I have created a report that is linked to the form. When I click the preview command button it asks for Emp. ID I enter in the ID Number and click ok. The print preview screen shows up with nothing on it. How can I get the data to show up on the report? and when I create complete report how can I get each Employee ID number on a separate page from the next.

Software/Hardware used:
ASKED: April 16, 2009  5:51 PM
UPDATED: April 19, 2009  8:32 AM
RELATED QUESTIONS
Answer Wiki:
This looks like you have control element with data (emp.id) which absent from query underlying report. To print on separate page the data for each Employee ID number, add group by this column and set a page break at the beginning of this group.
Last Wiki Answer Submitted:  April 19, 2009  8:32 am  by  msi77   1,610 pts.
All Answer Wiki Contributors:  msi77   1,610 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Have you tried running the report’s query directly against the database with the same Emp. Id you entered when running the report from the form ? does it return rows ?

carlosdl
 63,580 pts.