Have more than one record on one page

[Francesca]

Hello,

I have created a report that contains a rectangle with
many text fields inside. My problem is that each
rectangle/record prints on a seperate page. I want the
rectangles to follow each other cause they they are quite
small in width and each don't need to be on their own
page..

Can someone help with this...

Thanks

 

[Duane Hookom]

Records (detail sections) will normally print as many on a page as there is
room to print. This can be modified the the report designer by inserting
page breaks, add breaking before or after groups, or adjusting sizes of
sections.

 

[Guest]

Thanks..

I have another question...I have created a database that
handles asset inventory.

I have been working on a report called summary of assets
but I only want the summary to be for the one individual.
In my report I currently have a emp # field but is there
any way that I could have some sort of drop down menu on
my form and when you pick an employee number from the list
it generates and brings up a summary of assets report for
that individual?

 

[Dejan]

How to print report for the specific emp #:

Dim srtWhere as str

 

[Duane Hookom]

Assuming the field is numeric and you have code created by the wizard, your
code might look like:
Dim strWhere as String
strWhere = "[EmpNum] = " & me.cboEmpNum
DoCmd.OpenReport "rptEmpAssets", acViewPreview, , strWhere