Record Navigation Buttons

[Guest]

Is there an event which is triggered when I use the record navigation arrows
on the bottom of the form?

-David

 

[Guest]

The form's Current event will fire. If there are others, I am not aware of
them.

 

[Guest]

Oh, probably the After Update as well, I don't know about the Before Update

 

[Brendan Reynolds]

There are a number of events that are triggered when you move from one
record to another. These events are triggered regardless of what method was
used to move from one record to another. There isn't any event that is
trigged *only* when you use the record navigation buttons.

Here's a link to the relevant on-line help topic ...
http://office.microsoft.com/assistance/hfws.aspx?AssetID=HP051867611033

 

[Guest]

I have narrowed down the problem. The query I am using is apparently read
only I am assuming because it has left joins.

My desired sequence is as follows:
Open my query into a form
When the record changes, check to see if the value of a dropdown (open /
closed)
has changed
Save data

The problem is, AfterUpdate and BeforeUpdate are never triggered because the
result set is read only.
Form Current I use to populate a few fields, so they can be modified, but by
the time it has run, we have already moved from the old record to the new...

 

[Guest]

As an update, I decided to solve this problem by separating my form into 2
queries. One contains non-joined information to be updates, and the second
conains all of the data with joins.

When the form current fires, I query the 2nd query and populate the form
fields with the static data.

If you can think of a vastly different and better way to do this I'd love to
know, thanks!