How make query run ONLY if data on a form has been changed
What event do I use to run a query ONLY of data on a form has changed? I thought it would be afterupdate but even if I haven't changed anything on the current form's data the query seems to want to run.
ASKER
Hmmm. I have it in the afterupdate event of the form but the query is trying to run even if I haven't changed any data in the current record.
Something your doing must be making the record dirty.
Turn the record selectors on and then watch when it changes to a pencil. That's the point the record is considered changed.
Another check:
1. Call the record up.
2. Hit esc twice (undo control and undo form).
3. Now close the form. You should find that your query does not run.
Jim.
Turn the record selectors on and then watch when it changes to a pencil. That's the point the record is considered changed.
Another check:
1. Call the record up.
2. Hit esc twice (undo control and undo form).
3. Now close the form. You should find that your query does not run.
Jim.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Note that if you change a control, then change it back, it's still considered a change.
Jim.