What Event Procedure Parameter do I want? (1 Viewer)

Mike1sMike

New member
Local time
Today, 02:03
Joined
Apr 24, 2020
Messages
16
I have a form with with two subforms. All works well and an Event Procedure tied to Double Clicking an event procedure
(Forms![SkidTime]![WorkorderSkidTrackingQrysubform].Form.Requery) works well. What do I would like to do is have it update as soon as I change one control. None of the other options seem to work and in fact seem to be ignored. Dirty and Update will work if I go back to a control I changed and change it again but that makes no sense...
 

June7

AWF VIP
Local time
Yesterday, 23:03
Joined
Mar 9, 2014
Messages
5,424
Code in each control's AfterUpdate event.

However, Requery sets focus to first record on form. Do you really want that?
 

strive4peace

AWF VIP
Local time
Today, 02:03
Joined
Apr 3, 2020
Messages
1,003
hi Mike,

Welcome to AWF ~

> "have it update as soon as I change one control "

when you change that control*, save the record. Perhaps you might need to requery other controls on that form's AfterUpdate event.

* adding on:
as June said, this could be done on the control's AfterUpdate event, but if you're using code to write the value, you'll need to trigger the event yourself
 

Users who are viewing this thread

Top Bottom