HOw to tie an update query to on open of a report

  • Thread starter Thread starter Barb
  • Start date Start date
B

Barb

Right now I have an event procedure on The Open of the
Invoice report that declares some integers for late.
What line of code do I put in to run an update query on
the OPEN of the report.do I just put it right before the
end sub of the other integer declarations?? for the data
source for the query do I still keep the previous select
query??

Thanks so much,---See below
Barb

Previous REply from Sept 1 .
What about an update query, and in the update to enter:
IIF([printdate] is null,now(),printdate)
You can run the update query at report open
Hope this helps.Fons
 
Barb

Just because you "ran" a report doesn't mean you actually succeeded, does
it? How will Access be able to tell that a report was actually printed (vs.
being sent to a printer and canceled)?

If you have a query you use to "get" the data for your report, you could use
an update query, based on that query, to run after YOU decide the report was
successful. This would require you to add a new field to a table, before
you could store either Date() or Now() via that update query.
 
Back
Top