Urgent Help!!

[jrmellis]

How can I print the results of a form search which changes based on criteria selected by user and the result is displayed in a list box on another form. (The latter is what I want to print)

 

[Jbozward]

You could have a combo box that selects the data you want to query, then open a new form with:

[Whatever]='Whatever'
in the filter property.

this will limit that form to the data selected, and on the onopen or onload property, you could build code to print and close it automatically.

Dunno if this is any help, only the question is a bit vague...!!!!!

 

[jrmellis]

Thanks much. The thing is, I know that the code should go in the onopen event but it is the code that I do not know how to build. My form will consist of data on Areas, Distance, Elevation, Site Code and Parish Name. These are not all present at the same time as it depends on the criter selectd by the user. So at times there will be Site Code, Parish Name and Area and other times there will be something different.

What I want to be able to do is to use the RecordSource of the Form to create and print a report. Then the report will give the same info that the form gives.

I hope that makes it a bit clearer.