print only first page

[travismp]

I have a form... everything looks good. Sometimes it pulls 5 records, sometimes only 2....

Is there a way to only print the first result no matter what. Whenever there is an extra couple results I do not want those to print.

Thanks all...

peace

 

[TedMartin]

How about opening the form and selecting the first record by docmd.gotorecord,,acfirst - read all the data fields into public variables and then just print those off on the report? Note - you will need to set focus on each field to get the variable to record the data.