Report produced from a Form

V

van

I have created a form, which consists of a number of fields on one line.
And have made the default view continuous form, so a large number of records
can be viewed at once. I have one particular field, which a user can enter
Y or N into, indicating whether they would like to print that particular
record.

I would like to be able to produce a REPORT at the click of a button from
the form, based on whether the user entered Y in the field criteria as
discussed above. Any ideas?

Thanks
 
J

JohnFol

I sort of disagree with sprinks slightly.

Why not do a simple Docmd.OpenReport using a where condition, or encase the
docmd.OpenReport in an If condition (Field="Y")
 
V

van

Thanks for your help. I have set up a query on the condition that the field
=Y.

I now have the problem, that I would like to sort the fields in the form.
While this is relatively simple, I need the user to be able to define which
fields they want to sort on. The number of fields they choose to sort on
may differ from time to time. I then need to produce a report based on the
results of the form sort. How could this user defined input be captured?

Any suggestions on how this could be done?
 
J

JohnFol

You will need to create the SQL dynamically, based upon the yes/no values
selectde against each field
 
Top