I have a report that fits on 1/3 page landscape...

[AidanEnos]

What I am trying to accomplish long winded is this...

Main Switchboard Command button
On Click Opens Unbound form "CustomerIDSelect"
CustomerIDSelect After Upate Opens Query "EndUserInformationQuery"

This Query has all of the fields in the EndUserInformationTable - they are to be displayed in the report. The Query has only 1 criteria...

DLookUp("SmartName","CustomerIDSelectForm","SmartName = '" & [SmartName] & "'")

Essentially this criteria is designed to take the selection made from the CustomerIDSelectForm, use that result as the 'filter' for the report and run the report.

Now... the report fits 3 wide on a standard page in Landscape format. I am having some limited successes along the way - I'm finding that the Criteria isn't having any impact on what records are retreived... and that the report only puts 1 record per page - where I want it to put 3.

Any advice or what additional information can I provide to help this make more sense.

Thanks.

 

[GingerR]

So you have a form, and on the AfterUpdate event of the form, a query opens? Why not just have the report open?

Your statement would have the WHERE portion of the code filled in:

Docmd.OpenReport "ReportName",acviewpreview,,"SmartName = '" & Forms!CustomerIDSelectForm! & "'"

Alternately, if you want to put the criteria right into the Recordsource of the Report, it'd be:

=Forms!CustomerIDSelectForm!SmartName

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html