G
Guest
Is there an event which is triggered when I use the record navigation arrows
on the bottom of the form?
-David
on the bottom of the form?
-David
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
The form's Current event will fire. If there are others, I am not aware of
them.
them.
G
Guest
Oh, probably the After Update as well, I don't know about the Before Update
B
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
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
G
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...
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...
G
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!
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!