printing reports from info on a form

[binghamw]

I think this may be quite easy but I have a form that is based on a search result. I want the user to be able to hit a button to print the form with the fields (and what's in the combo boxes) that he/she has selected.
It seems easy enough to make a form, but how to make a form based on the search results from a form seems a bit tricky.

any ideas?

 

[RichO]

If all of the controls on your form are bound to a table, you can run a report on that table and use the filter property to get only the current record in the form.

Otherwise, you would have to set up the controls on your report to look at the controls on the form, ie:

[Forms]![MyForm]![MyControl]

 

[binghamw]

this is working just great.

However, it is printing out 11 pages when I just want one. I can't figure out why it's doing this.

Help!

 

[RichO]

What is it printing on the 11 pages?