questions for an onclose report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello all...

I have a report that I use for order entry, when the user opens the
report, I would like the report save to my C:/ Drive? how do I do this?

Also, when the user closes the report, I want a specific field within my
tblorders to be updated? So, when the user opens my report "orderprinted" is
false, but when they close the report , it is changed to "true"

thanks in advance ....

Brook
 
1. the best way to save a report on your c drive its to save it as a pdf
file, or msi
2. on your report download run an update query to update your field to true
and on the load property of your report the query will update the fiels to
false
 
Thank you for the information,

Can you elaborate on your suggestions? I have never done either of these,
so I am unsure where to get started.

Brook
 
in your report proerties there load and unload events, open the code for each
one of them and write the following (change the name to suite you)
on the unload
docmd.rubsql UPDATE MyTable SET MyField = True
WHERE MyFilterField = MyParam"

change from True to false when you load
 
I created my rptneworders, and set the filter to "on" and the filter property
to PrintOrder=false.

However, I don't know where to go from here? I create an update query that
works, but I don't see the onload or unload that you mention?

Thanks,

Brook
 
Hi Brook
On the report there are proprties for each field, or for the report.
To get the properties of the report just press the corner of the report, on
the propeties you'll find ""on load and unload properties.
 
Back
Top