View Full Version : printing reports from info on a form


binghamw
04-29-2004, 08:18 AM
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
04-29-2004, 12:15 PM
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
05-04-2004, 01:07 PM
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
05-04-2004, 05:53 PM
What is it printing on the 11 pages?