Moving To Previous Page

  • Thread starter Thread starter Connie
  • Start date Start date
C

Connie

What event is triggered when you are returning to a previous page in a
report? What I'm trying to accomplish is I have a custom toolbar & based on
what's on the current page a button will be either enabled or disabled. I
have this working going forward, but when a user returns to a previous page
I need an event that will trigger so I can use same code.

TIA
 
Connie

The "Report" and the "Detail" sections have an OnRetreat event -- is that
what you are looking for?
 
Thanks for your suggestion, Jeff. I thought so too. From the help section
it sounded exactly what I was looking for, but it doesn't seem to trigger.
So I was hoping someone could tell me if in fact there is an event that gets
triggered when previewing previous pages.

Or maybe there's another way to approach my problem. To explain a little
more in detail. My report consist of invoices based on the store or stores
a user will select from a form (using a list box) before previewing. I've
created a custom button called "Finalize Invoice" on a custom toolbar, which
then writes everything into the Invoice table among other things. Then this
button is disabled, preventing user from Finalizing it again. When the
report is opened, I have code that checks if invoice (current page) has been
finalized ... if it has the button is disabled, if not it's enabled. Here's
my dilemma: If a user selects 1 store & finalizes it, then comes back in &
not only selects that store but another store that hasn't been finalized, I
need to have the button enabled for 1 but not the other. It works just fine
going forward, but whatever the state of the button is on the last viewed
invoice remains going backwards.

any ideas are definitely appreciated!
Connie
 
Connie said:
My report consist of invoices based on the store or stores
a user will select from a form (using a list box) before previewing. I've
created a custom button called "Finalize Invoice" on a custom toolbar, which
then writes everything into the Invoice table among other things. Then this
button is disabled, preventing user from Finalizing it again. When the
report is opened, I have code that checks if invoice (current page) has been
finalized ... if it has the button is disabled, if not it's enabled. Here's
my dilemma: If a user selects 1 store & finalizes it, then comes back in &
not only selects that store but another store that hasn't been finalized, I
need to have the button enabled for 1 but not the other. It works just fine
going forward, but whatever the state of the button is on the last viewed
invoice remains going backwards.
Click to expand...


Connie, this approach is doomed. Reports are just a static
presentation of a snapshot of your data, they are not
amenable to interactive data changes. Instead, you should
use a form for this kind of operation.
 
Well ... not what I wanted to hear, but now that I know it's a dead end, I
won't spend anymore time on it.

Thanks, Marsh, for the info
Connie
 
Back
Top