Report produced from a Form

  • Thread starter Thread starter van
  • Start date Start date
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
 
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")
 
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?
 
You will need to create the SQL dynamically, based upon the yes/no values
selectde against each field
 
Back
Top